Subject | Database maintainance |
---|---|
Author | Christian Kaufmann |
Post date | 2004-06-30T07:06:09Z |
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
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