Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Detecting deadlocks

Re: Detecting deadlocks

From: Matt <zagnimp_at_aom.bt.co.uk>
Date: Fri, 26 Oct 2001 10:21:26 +0100
Message-ID: <3BD92B16.F86117D1@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 - 04:21:26 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US