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: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 26 Oct 2001 15:00:14 -0700
Message-ID: <9rcmde0291t@drn.newsguy.com>


In article <3BD92B16.F86117D1_at_aom.bt.co.uk>, Matt says...
>
>Yep thats correct but is there anyway of monitoring them fully via
>a script and tracing where and why they happen ?
>

all you can get is in the trace file listed in the alert log.

deadlocks don't last long enough for you to monitor them. As fast as they happen-- they go away (one of the sessions "lose")

>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.
>

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp 
Received on Fri Oct 26 2001 - 17:00:14 CDT

Original text of this message

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