Subject Re: [firebird-support] OAT stuck --> OIT stuck --> Lost Performance
Author Pavel Cisar
Danny Garcia Hernandez wrote:
> Hi, i was reading some days ago that IB 7.1 and later have a new suppor
> to prevent OAT stuck with indefinitely active read only read committed
> transaction, that´s true?.
> It´s posible in FB?. How?.

Yes, it is, and it's nothing new even in IB 7.1 (maybe newly
documented). Transaction started with isolation level read committed and
read_only option will never block OAT to advance. Because they always
see the latest row version (read committed) and can't made any changes
(read only), they could be internally treated as pre-committed.

best regards
Pavel Cisar