locks and locked objects
==============================
select /*+RULE*/
s.machine,
s.osuser "O/S-User/",
s.username "Ora-User/",
s.sid "Session-ID/",
s.serial# "Serial/",
s.process "Process-ID/",
s.status "Status/",
l.name "Obj Locked/",
l.mode_held "Lock Mode/"
from v$session s,
dba_dml_locks l,
v$process p
where l.session_id = s.sid and p.addr = s.paddr
locks and which sql cause it
==================================
select /*+RULE*/
s.machine,
s.osuser "O/S-User/",
s.username "Ora-User/",
s.sid "Session-ID/",
s.serial# "Serial/",
s.process "Process-ID/",
s.status "Status/",
l.name "Obj Locked/",
l.mode_held "Lock Mode/",
t.SQL_TEXT,
t.COMMAND_TYPE
from v$session s,
dba_dml_locks l,
v$process p ,
v$sqltext t
where l.session_id = s.sid and p.addr = s.paddr
and t.HASH_VALUE=s.sql_hash_value
order by s.sid,t.ADDRESS,l.name, t.PIECE
oraclehu 20050927 12:39