Re: Oracle 8.16 Deadlock

Your answer is totally irrelevant. He got ORA-4020, not ORA-60. There's no easy way to fix this. The only thing I can think of is check and make sure there's no invalid objects. I'm waiting for expert opinions.

Yong Huang
yong321_at_yahoo.com

buckeye234_at_excite.com (Patrick) wrote in message news:<3bbfc440.0201101037.613ec591_at_posting.google.com>...
> "Peter Lasner" <plasner_at_de.imshealth.com> wrote in message news:<3c3d8bff_4_at_news2.prserv.net>...
> > Does someone know any circumstances so that one session is blocking itself ?
> > The trace says:
> > ORA-04020: deadlock detected while trying to lock object
> > T49PDGI.PDGI_COUNTRIES
> > --------------------------------------------------------
> > object waiting waiting blocking blocking
> > handle session lock mode session lock mode
> > -------- -------- -------- ---- -------- -------- ----
> > 3d892524 3b643688 3bb2b8dc X 3b643688 38dbcae0 S
> >
> > I use Oracle 8.16 on AIX
> > Thank you in advance
>
> I ran into this a year or so ago. In my case, the underlying cause
> was due to the inability to get a slot in the ITL. This was a third
> party app and they had created the table with a PCTFREE of 10.
Received on Thu Jan 10 2002 - 22:34:28 CST