Re: Detecting deadlocks

From: Christopher Latta <nobody_at_nowhere.not>
Date: Fri, 26 Oct 2001 20:50:21 +1000
Message-ID: <3bd94324.0@mercury.planet.net.au>

In {OracleHome}/rdbmsXX/admin there's a script called utllockt.sql which displays a lock tree. No results = no locks. Its handy when you have a lock situation to find out who is locking the system.

Christopher Latta

XX = your version number

Matt <zagnimp_at_aom.bt.co.uk> wrote in message news:3BD92B16.F86117D1_at_aom.bt.co.uk...
> Yep thats correct but is there anyway of monitoring them fully via
> a script and tracing where and why they happen ?
>
> Ban Spam wrote:
>
> > Matt <zagnimp_at_aom.bt.co.uk> wrote in
news:3BD84493.F15B22D7_at_aom.bt.co.uk:
> >
> > > Hi,
> > >
> > > Are there any useful scripts for monitoring deadlocks in oracle
> > > examples please..
> > >
> > > Regards
> > >
> > > Matt
> > >
> > >
> >
> > Honest to goodness deadlock will be reported in the alert_SID.log file.
>
Received on Fri Oct 26 2001 - 05:50:21 CDT