At 03:26 PM 15/12/2004 +0800, you wrote:

>Hello,
>
>As we speak, my database has an OAT of 4118147 and OIT of 1561932,
>which gives a gap of
>2556215. I've done a sweep (during an online database) but it seems
>that the gap does not move. I can't understand that really.
>
> >From my observation, Next transaction keeps on increasing, while OAT,
>OIT keeps static. For today so far, OAT and OIT hasn't moved since
>8.30 a.m till 3.24 p.m.
>We have an average of 100 transactions every 4 seconds.

Well, the classic answer here is that your application code is holding
transactions open indefinitely. As long as you have a transaction open,
not hard-committed, not rolled back, it remains active. As long as you
have rolled back transactions, they remain "interesting" until garbage
collection or sweeping makes them "uninteresting".

If you have COMMIT RETAINING happening to transactions all over the system,
with no hard commits, those transacs just remain active and interesting
forever -- which is why If GC and sweeping don't clear them up.

>--
>There are many ways of going forward, but there is only one way of
>standing still --- unless you are talking about Commit Retaining. :-))

./hb