Subject Re: [firebird-support] Problem with FB database that freezes
Author Alexey Kovyazin

OAT is an active transaction. You can see it alive if you analyze MON$ snaphot (you can use trial of our FBMonLogger).

So, disconnects are not related with Next-OAT gap - because this gap is caused by some open transaction which you can easily identify.

However, disconnects can lead to forced rollback, and as a result, OIT could stuck, and it will lead to increased gap OIT-OST, which is also not good.

For more details about OIT, OST and OAT read this ppt

Alexey Kovyazin


Hi there,

Can the connection errors in the log contribute to the increasing gap between the OAT and NT?