Identifying the Locking statement
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Identifying the Locking statement

  1. #1
    Join Date
    Sep 2008
    Posts
    10

    Identifying the Locking statement

    I could see 5 session IDs (Lock holder) in my DB. I could see Enq wait in my DB. But I would like to see which statement is causing that lock in those Session IDs... could not able to.

    Can anyone help me pls

    Thx

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,459

    Talking SQL Hash Value

    From Enterprise Manager: Targets => Database

    Select database => Performance => Instance Locks => Blocking Locks

    Select: Session ID or SQL Hash Value
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  3. #3
    Join Date
    Sep 2008
    Posts
    10
    we dont have OEM - :(

    any statement will help me

    thx

  4. #4
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,997
    Look at dba_blockers and dba_waiters. You can then look at v$sqlarea to find the sql being run via sql_id. v$session_longops might also be useful.
    this space intentionally left blank

  5. #5
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,459

    Talking emca

    Quote Originally Posted by ruma1948
    we dont have OEM - :(

    any statement will help me

    thx
    Yes you do have OEM, in 9i you can install the EM database console from the 'client' installation CD or download. For 10g you just execute emca which you can find under the ?/bin diractoy (or install from the client sw).
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  6. #6
    Join Date
    Nov 2002
    Location
    Mooresville, NC
    Posts
    349
    Use this ...
    Attached Files Attached Files
    • File Type: txt g.txt (4.5 KB, 60 views)
    http://www.perf-engg.com
    A performance engineering forum

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