Can somebody please explain to me the difference between OIT and OAT.
OIT = is the first transaction in a state other than committed in the
database's Transaction Inventory Pages (TIP)
OAT = is the first transaction marked as active in the TIP pages
Sorry, but for me, it sounds equal.


The next point, that is not clear to me, is the sweep-interval. When
OIT-OAT>sweep-interval, then the garbage collection starts. The
default-value of the sweep-interval is 20000, but when you end the
transactions as soon as possible (as it is supposed), then the
difference between OIT and OAT will never become so large and so the
garbage collection will never start. Is this right or am I totally wrong
?



Guido.