Oracle锁调查的脚本

select
/*+ NO_MERGER(a) NO_MERGE(b) NO_MERGER(c)*/
a.USERNAME,
a.MACHINE,
a.SID,
a.SERIAL#,
a.LAST_CALL_ET "Sec",
b.ID1,
c.SQL_TEXT "SQL"
from v$session a, v$lock b, v$sqltext c
where a.USERNAME is not null
and a.LOCKWAIT = b.KADDR
and a.SQL_HASH_VALUE = c.HASH_VALUE[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/9907339/viewspace-1056734/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/9907339/viewspace-1056734/