Re: [HELP] How can I find deadlocks?

Manoli Alamo Medina <sscc.malamo_at_aena.es> writes:

>Hi,
 

>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 mailto:sscc.malamo_at_aena.es)
>Thanks in advance!
>Manoli Alamo

Manoli,

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:

utllockt.sql

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:                    <->
<->                                                               <->
<->              http://homepage.interaccess.com/~akaplan         <->
<->                                                               <->
<->             email: akaplan_at_interaccess.com                    <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->