Re: Oracle detects deadlock (ORA-00060) with just one session open

From: VC <boston103_at_hotmail.com>
Date: Tue, 24 Aug 2004 10:03:18 GMT
Message-ID: <GnEWc.223518$eM2.73546@attbi_s51>

Hello,

"André Hartmann" <andrehartmann_at_hotmail.com> wrote in message news:412af85b_at_olaf.komtel.net...
> > The self-deadlock similar to yours was happenning under Oracle 8i when
> > MAXTRANS was <3 on the lob index. Allegedly, it was fixed in 8.1.x.
A
> > work-around was to increase MAXTRANS in the lob index.
>
> The problem occurs on an Oracle 9i server running under AIX.

I undestand that. However, your trace file is exctly the same as it would have been if the error had happened under 8i. Did you try increasing MAXTRANS ?
>
> AH
> :)
>
>
>
Received on Tue Aug 24 2004 - 05:03:18 CDT