Subject Re: [IBO] OAT
Author Aage Johansen
>> Paul wrote:
>> I suspect I have OAT problems and would appreciate some help as to
>> where to look.

>Svein Erling wrote:
> I'd say you do have a problem. I do not know how many transactions your
> system use each day, but I'd guess way below 700000. Hence, there is one
> transaction that was started days/weeks/years ago that still has not been
> committed.
> ...

Sometimes, the OAT seems to get "stuck" - maybe from some largish rollback.
The usual options are sweep (in single user mode) and backup+restore. The
backup+restore may be the fastest one (backup _without_ garbage collecting!).

Aage J.