|Subject||Re: [IBO] OAT|
>> Paul wrote:Sometimes, the OAT seems to get "stuck" - maybe from some largish rollback.
>> 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
The usual options are sweep (in single user mode) and backup+restore. The
backup+restore may be the fastest one (backup _without_ garbage collecting!).