Re: Deadlock resolution

"Galen Boyer" <galenboyer_at_hotpop.com> wrote in message news:ud68asvld.fsf_at_standardandpoors.com...
> On Thu, 19 Feb 2004, gooiditweg_at_sybrandb.demon.nl wrote:
> > On 19 Feb 2004 11:12:17 -0600, Galen Boyer
> > <galenboyer_at_hotpop.com> wrote:
> >
> >>The hard thing is that Oracle doesn't tell you what objects
> >>were involved in the deadlock, and it can be anything.
> >
> > I don't think this is true. Ora-060 will always result in a
> > trace file with detailed info about open cursors, lockmodes
> > etc.
>
> Hm... Sets up a deadlock situation... Looks at trace file.
>
> I'll be damned. I solved an insidious deadlocking issue a few
> weeks ago and didn't use that info. How many times do I have to
> tell myself, just look at the trace file you dummy!
>
> --
> Galen Boyer

LOL! I remember the first time I got the "instance terminated disconnection forced' error message with 9i... panic! terror!... bloody Linux!!.. I thought I must have done the Linux or Oracle installs wrong, so was about to re-install the lot... when I thought, "hang on, let's just look at the alert log" -it's what I always drill into students, after all. Sure enough: incorrect undo tablespace name. Phew!

Regards
HJR

-- 
--------------------------------------------
Oracle Insights: www.dizwell.com
--------------------------------------------