Subject RE: [firebird-support] FB 2.1.1 - gstat x mon$ tables: which is correct?
Author bogdan
>1. Now, I am loster than before... :-)

>2. There is no gargage collection from 04:00 through 22:00. At midnight, a cron job does backup and restore every day.

>3. No. :-) Maybe, I wish firebird .conf would have an option that after one transaction were open for a long time, i.g. 15 minutes, it would be >automatically commited or rolled back... When mon$ transactions are commited?

>4. I have just made gstat, commit, select mon$, commit and gstat again, and the numbers are:

>Mon Nov 10 10:39:34 BRST 2008

>Oldest transaction 325
>Oldest active 326
>Oldest snapshot 326
>Next transaction 21455
>Attributes force write, no reserve
>Sweep interval: 0





Btw, why do you have »no reserve« attribute set for database ??

Regards,

Bogdan



[Non-text portions of this message have been removed]