Thank you for the advice, currently our "read only" transactions are not true "read" only, they contain the "write" parameter - I will try to change them tonight (should be possible)

More importantly then are you saying that "truly read-only" transactions are not counted as "interesting active transactions" and garbage collection will proceed even if one exists that has been running for e.g. 30 days?

Once again, I cannot thank all of you for the quick and helpful responses

> read-only transaction must be real read-only, not "logically read-only". So, you
> need to set this transaction parameters to
>
> read
> read_committed
> rec_version
> nowait
>
> --
> Dmitry Kuzmenko, www.ib-aid.com
>