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
] 
Blog
Search
Help
Members
Register
Login
Home
