Hi,
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
http://www.slideshare.net/ibsurgeon/3-how-transactionswork
Regards,
Alexey Kovyazin
IBSurgeon
Hi there,
Can the connection errors in the log contribute to the increasing gap
between the OAT and NT?
Regards,
-Eduardo