Anne -

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Ann Harrison
Sent: Thursday, August 18, 2011 4:50 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Oldest transaction stuck

>>
>> Database header page information:
>>
>>
>> Oldest transaction 12778
>>
>> Oldest active 24126761
>>
>> Oldest snapshot 24126761
>>
>> Next transaction 24152614
>>
>>
>>
>> My understanding was that I do not need to run a manual sweep if I

am

>> running gbak each night (with garbage collection enabled, of

course).

>> The question is, do I need to run a sweep on this DB, or is there
>> something else that is preventing the OIT from advancing?
>>
>
>Don't worry about it. Oldest active is a problem, and OIT was a

problem with classic on small memory systems that have been gone for a
decade. If it bothers >you, run a sweep after a garbage collectung
backup

Ah, that makes me feel much better!

Thanks.