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
