-
Hi all,
I am getting the following error while shutting down my oracle server.this is pmon trace file.
<< Oracle process number: 2
Unix process pid: 7266, image:
*** SESSION ID:(1.1) 2001.11.25.03.20.53.000
*** 2001.11.25.03.20.53.000
found process 4300bc74 pid=15 serial=1 dead
*** 2001.11.25.03.20.54.000
deleting process 4300bc74 pid=15 seq=1
Lock conflict, transaction wait xid: 0x0004.02a.00101333
deletion of process 4300bc74 pid=15 seq=1 unsuccessful>>
I understood this is because of lock conflict,but don't know how to appoach further.could u please suggest me
-
UTLLOCKT.SQL script in RDBMS/Admin dir can be run after logging in as sys user to determine lock contention.
This script uses DD views like V$Access and V$Session_wait to determine lock contention. A potential drawback is that this utility itself acquires some locks.
Another method:
Select * from V$session_wait where LOCKWAIT is not null;
Value in COMMAND column tells what operation is happening.