Subject | OIT moving when closing connection |
---|---|
Author | mivi71dk |
Post date | 2002-06-27T11:16:18Z |
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
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