Newsgroups: comp.databases.oracle.server,comp.databases.oracle.misc
Subject: Re: [HELP] How can I find deadlocks?
References: <3353517C.2AA0@aena.es>
Manoli Alamo Medina 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@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: <->
<-> <->
<-> www.arikaplan.com <->
<-> <->
<-> email: akaplan@interaccess.com <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
Back to Ari Kaplan's Home Page