DeadLock Graph Analyze
I need some help on analyze deadlock graphs.
database version is 188.8.131.52
This is my DeadLock Graph:
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.
Click Here to Expand Forum to Full Width