Subject | When does OIT = OAT? |
---|---|
Author | ruan_h |
Post date | 2012-09-30T04:09:27Z |
Hi
OIT is the first transaction in a state other than committed.
OAT is the first transaction marked as active.
So if I have committed all the transactions, shouldn't OIT = OAT? But what I found is OAT is always 1 higher than OIT.
First I create a new database, the stats are
Oldest transaction 1
Oldest active 0
Oldest snapshot 0
Next transaction 1
Why would OIT = Next Transaction?
I then connect to the database via isql and then disconnect, the stats are
Oldest transaction 1
Oldest active 2
Oldest snapshot 2
Next transaction 3
What does OIT = 1 mean here?
I then run a few transactions in one connection and commit them all, but in the stats, OAT still = OIT + 1.
Thanks
Huan
OIT is the first transaction in a state other than committed.
OAT is the first transaction marked as active.
So if I have committed all the transactions, shouldn't OIT = OAT? But what I found is OAT is always 1 higher than OIT.
First I create a new database, the stats are
Oldest transaction 1
Oldest active 0
Oldest snapshot 0
Next transaction 1
Why would OIT = Next Transaction?
I then connect to the database via isql and then disconnect, the stats are
Oldest transaction 1
Oldest active 2
Oldest snapshot 2
Next transaction 3
What does OIT = 1 mean here?
I then run a few transactions in one connection and commit them all, but in the stats, OAT still = OIT + 1.
Thanks
Huan