Subject Re: [firebird-support] Database maintainance
Author Ann W. Harrison
At 03:06 AM 6/30/2004, Christian Kaufmann wrote:

>In one of my main database I have the following values in the statistic:
>Database header page information:
> ...
> Oldest transaction 101776
> Oldest active 120984
> Oldest snapshot 120984
> Next transaction 120987
> ...
>What exactly do I have to do, to clean up the big difference to "Oldest
>transaction" ? Should I set the Sweep interval to 0 and perform a manual
>sweep during the night?

That's probably a good idea. Sweep will update the oldest
transaction, whether or not it's run standalone. However,
sweeping while people are trying to get work done can be