oracle erp locks info

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

阅读更多
文章标签: oracle session sql
个人分类: Oracle ERP/DBA
上一篇patching oracle erp 11i
下一篇oracle advance security option
想对作者说点什么? 我来说一句

没有更多推荐了,返回首页

关闭
关闭
关闭