Oracle鎖調查的指令碼

maojinyu發表於2011-12-07
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/,如需轉載,請註明出處,否則將追究法律責任。

相關文章