From: "Daniel Rail" <daniel@...>

> > Oldest transaction 40298
> > Oldest active 40299
> > Oldest snapshot 40247
> > Next transaction 41004
>
> Have you tried to perform a sweep? I know you have sweep set to 1000,
> but that simply means that the sweep is performed after 1000
> transactions.

No, automatic sweep will be started when the difference between the OAT and OIT is 1000.
(so it is possible that it will never be started automatically)


Ivan Prenosil
[ I am looking for a job: InterBase - Firebird - Delphi - C - fulltext db - and more ... ]
Ivan.Prenosil@...
http://www.volny.cz/iprenosil/interbase