> 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
>
>
>