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



  • [firebird-supp... conver...@gmail.com [firebird-support]
    • Re: [fire... Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
      • Re: [... conver...@gmail.com [firebird-support]
        • R... 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]
        • R... Thomas Steinmaurer t...@iblogmanager.com [firebird-support]
          • ... Thomas Steinmaurer t...@iblogmanager.com [firebird-support]
          • ... conver...@gmail.com [firebird-support]
        • R... Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
          • ... conver...@gmail.com [firebird-support]
            • ... Alexey Kovyazin a...@ib-aid.com [firebird-support]

Reply via email to