Subject When does OIT = OAT?
Author ruan_h
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