Subject OIT moving when closing connection
Author mivi71dk
Hi

How come that the difference between my Oldest Transaction, Oldest
Active and NExt Transaction continues to have a big gab until I
disconnect from the DB ?

This only happens when two or more clients are connected.

I.e. I can have values as

Oldest transaction 21844
Oldest Active 21849
Next Transaction 21898


Eventhough all client appl (2 in this case) has done a commit.

Then when one of them closes, it all changes, so that oldest active
is 1 below next transaction and oldest transaction i 2 below.


In this specific case it doesn't do anything since all client
programs closes every evening, and then the OIT moves along.

I just thought it would move along whenever a client appl. did a
commit.

Michael