Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

locking problem with tables

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0
hi i have a problem here i am facing a situation of dead lock in my database i am unable to find which particular table is getting locked and which is the session locking it.Is there any idea of finding the locked table and session locking it pl do reply immediatley
thanx in adv.
 
select l.lmode, l.sid, l.id1, o.object_name
from v$lock l, dba_objects o
where type='TM' and o.object_id=l.id1
/
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top