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

From Enterprise Manager: Targets => Database

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

Select: Session ID or SQL Hash Value :rolleyes:

we dont have OEM - :(

any statement will help me

thx

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.

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).
:rolleyes:

Use this ...