Subject Re: [IBO] OAT
Author Aage Johansen
On Tue, 13 Jan 2004 09:28:54 +0000 (UTC), Paul Hope wrote:

>> 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!).

> Sweep has no effect so assume it's not rollback.

Did you try it in "single user mode" ?

> Backup+restore does remove it but its not a permanent solution

Right. If the problem is in an app you'll need to fix it - the only
permanent solution.
If it was just a rollback, there's not a lot to fix in the app :-) But a
'single user mode' sweep might fix the current gap - and it wouldn't bite
you until next time ...

Aage J.