-
DeadLock Graph Analyze
I need some help on analyze deadlock graphs.
database version is 8.1.7.4
This is my DeadLock Graph:
Deadlock graph:
---------Blocker(s)-------- ---------Waiter(s)---------
Resource Name process session holds waits process session holds waits
TX-000d0010-000092e0 33 33 X 15 15 X
TX-00130059-000093a9 15 15 X 33 33 X
session 33: DID 0001-0021-00000002 session 15: DID 0001-000F-00000002
session 15: DID 0001-000F-00000002 session 33: DID 0001-0021-00000002
Rows waited on:
Session 15: obj - rowid = 000042AB - AAAEKrAAgAAAkQ0AAA
Session 33: obj - rowid = 000042B4 - AAAF5qAAKAAAUM0AAF
I am using metalink note Note:131885.1. I try to follow that article to analyze deadlock graph. But I can't get any object name from dba_objects. I think I did not do a right conversion (decimal value of hexadecimal value) to get a object_id.
My application is siebel application with over 2300 tables. Deadlock just happened once on stress test. I don't know when it will happen again. Any help is welcome.
Thanks in advance for your help.
xyz
-
Hi
Code:
Session 15: obj - rowid = 000042AB - AAAEKrAAgAAAkQ0AAA
Sid 15 was waiting for ROWID 'AAAEKrAAgAAAkQ0AAA' of object 0x42AB
(which is 17067 in decimal)
Code:
Session 33: obj - rowid = 000042B4 - AAAF5qAAKAAAUM0AAF
Sid 33 was waiting for ROWID 'AAAF5qAAKAAAUM0AAF' of object 0x42B4
(which is 17076 in decimal)
You can find out the object name and object type as:
Code:
select owner,object_name,object_type from all_objects where object_id=17067;
select owner,object_name,object_type from all_objects where object_id=17076;
You can further dig down by :
Here the owner and the object_name is the result of the above querries.
Code:
select * from owner.object_name where ROWID='AAAEKrAAgAAAkQ0AAA';
select * from owner.object_name where ROWID='AAAF5qAAKAAAUM0AAF';
HTH
-
Thank you very much for your help.
I find my tables and rows now.
How do you learn to read this deadlock graphs? I am looking for documents and books on this. Please give me some book names or URL.
Do you know any program to read those trace files?
Thank you again for your help.
xyz