DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: DeadLock Graph Analyze

  1. #1
    Join Date
    Jan 2001
    Posts
    191

    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

  2. #2
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    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
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  3. #3
    Join Date
    Jan 2001
    Posts
    191
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width