Subject Database maintainance
Author Christian Kaufmann
Hi,

In one of my main database I have the following values in the statistic:

Database header page information:
Flags 0
Checksum 12345
Generation 120993
Page size 4096
ODS version 10.1
Oldest transaction 101776
Oldest active 120984
Oldest snapshot 120984
Next transaction 120987
Bumped transaction 1
Sequence number 0
Next attachment ID 0
Implementation ID 16
Shadow count 0
Page buffers 0
Next header page 0
Database dialect 3

Variable header data:
Sweep interval: 20000


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?

I'm using Win2000 with Firebird SS 1.5 as service

cu Christian