Home » RDBMS Server » Server Administration » dead lock
dead lock [message #265716] Fri, 07 September 2007 02:41
alantany
Messages: 115
Registered: July 2007
Senior Member

Hello,all:
I found a deadlock message in the trace file on a RAC db.

open lock on RM 0 0
*** 2007-09-05 02:09:12.866
user session for deadlock lock 7000002daeeef60
pid=163 serial=175 audsid=1417466022 user: 3402/ONEBOSS
O/S info: user: , term: , ospid: 1234, machine: IBOSS1_B1
program:
client info: 10.110.2.223
Current SQL Statement:
UPDATE TOBIMPSBIZPORTALMSG SET OPRRESULT=:1,HOPRTIME=:2 WHERE OPRNUMB=:3 AND IDVALUE=:4 and ACTIONCODE='0'
Global Wait-For-Graph(WFG) at ddTS[0.7] :
BLOCKED 7000002daeeef60 5 [0xc002d][0x679508],[TX] [65699,33] 0
BLOCKER 7000002e2611660 5 [0xc002d][0x679508],[TX] [131181,21] 1
BLOCKED 7000002e26117c8 5 [0x3000f][0x52324c],[TX] [131181,21] 1
BLOCKER 7000002daeeedf8 5 [0x3000f][0x52324c],[TX] [65699,33] 0

Could anyone tell me how to read this message?
Regards!
Alan

[Updated on: Fri, 07 September 2007 02:42]

Report message to a moderator

Previous Topic: about v$librarycache
Next Topic: rman error
Goto Forum:
  


Current Time: Sat Dec 10 01:03:01 CST 2016

Total time taken to generate the page: 0.24267 seconds