Subject: Re: [HELP] How can I find deadlocks?
References: <>

Manoli Alamo Medina  writes:


>I have a problem about deadlocks in ORACLE V7.1.4.
>Could anybody help me, about how to find them?
>(Please, send a copy of your post to
>Thanks in advance!
>Manoli Alamo


The most direct method to find if a deadlock occurred is to look in your 
bdump/udump directories. Deadlocks produce a trace file, giving the session
numbers (along with much more detail).

If you want to see which processes are generally locking out other processes,
you can look in the MONITOR LOCKS of SQL*DBA (before Oracle 7.3), or the
V$LOCK view.

Also, in your $ORACLE_HOME/rdbms/admin directory is a script called:


This will show you which processes are locking other processes, and which
processes are being locked. It's a great utility, shown in a tree structure.

Best of luck!

-Ari Kaplan
Independent Oracle DBA Consultant

<-> For 50+ technical tips, visit my Web Page:                    <->
<->                                                               <->
<->                                    <->
<->                                                               <->
<->             email:                    <->

Back to Ari Kaplan's Home Page tm">Back to Ari Kaplan's Home Page