> 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?
Yes. A long-running READ ONLY transaction in READ COMMITTED isolation mode doesn't block garbage collection. -- With regards, Thomas Steinmaurer http://www.upscene.com/ > 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 >> > > > > > ------------------------------------ > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > Visit http://www.firebirdsql.org and click the Resources item > on the main (top) menu. Try Knowledgebase and FAQ links ! > > Also search the knowledgebases at http://www.ibphoenix.com > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > Yahoo! Groups Links > > >