dennis wrote:

>
>
> Also please explain this gstat's counters:
>
> Oldest transaction 1007
>
> Oldest active 1008
>
> Oldest snapshot 1008
>
> Next transaction 18504685
>
> What really means this extreme difference?
>

It means that shortly after the database was created, someone
started a transaction that is still active 18.5 million
transactions later.

Even if searching the list archives is too hard, you might
try googling "Firebird oldest active". The first three hits
are all very good explanations of what these terms mean
and how to recognize and correct problems. In the invaluable
Firebird Book (Helen Borrie, available from IBPhoenix), look
in the index for OAT and OIT.


Regards,

Ann