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 >
