Subject Re: [IBO] OAT
Author Paul Hope
Hi Aage

> > Sweep has no effect so assume it's not rollback.
> Did you try it in "single user mode" ?
No - I'll do it tonight when they're all off.

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

I suppose it may be that forcibly disconnecting any users may release the
stuck transaction. There's no gap between OIT and OAT so according to the
articles it is a stuck transaction - I'll just have to find whats causing it