At 12:49 PM 20/06/2004 -0300, you wrote:

>Hello everyone... i was checking the statics from my database bue the
>Oldest transaction was 594353 and Oldest active was 594354....
>would be this possible ? The next transaction number is 598809... I use
>firebird 1.5 SS on linux server and restored this database after corruption...
>
>
>Database header page information:
> Flags 0
> Checksum 12345
> Generation 598817
> Page size 1024
> ODS version 10.1
> Oldest transaction 594353
> Oldest active 594354
> Oldest snapshot 571708
> Next transaction 598809
> Bumped transaction 1
> Sequence number 0
> Next attachment ID 0
> Implementation ID 19
> Shadow count 0
> Page buffers 0
> Next header page 0
> Database dialect 3
> Creation date May 31, 2004 12:13:56

This would be a weird set of stats if you are looking at a freshly restored
database, since the transaction id starts from 1 after a restore.

So, assuming it's not a freshly restored database, a difference of 4455
between oldest active and next transaction means you have passed 4454
transactions through the system since transaction 594354 started and trans.
594354 is still running. Is that realistic in terms of the work that's
under way at the time?

I notice that you have a page size of 1Kb. Is there some special reason
you need such a small page?

/heLen