Lock Conflict error

[jeyaseelan]

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

[Raminder]

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.