Hi All,

I am using Firebird 1.5.1 running on a Windows 2000 Server in a
production environment.

Here is an excerpt from the page information of my database

Database header page information:
Page size 8192
ODS version 10.1
Oldest transaction 758086
Oldest active 2462081
Oldest snapshot 2462081
Next transaction 2462082
Page buffers 10000
Database dialect 3
Creation date Sep 19, 2004 18:36:22
Attributes force write

Variable header data:
Sweep interval: 20000


So, as you can see there is a HUGE amount of garbage :(
Still don't know the reason but we are working on it.

This database is being backuped every night. GBAK runs without -G
switch. To my understanding, running GBAK the without -G switch will
effectively clear all garbage from the source database. So here comes
my first question - am I right about it?

My second question concerns the Sweep interval. The gap between OIT
and Next transaction is much more than 20000 so why garbage collection
did not start automatically?

Thanks in advance.

--
Best regards,
Alexander mailto:saho@...