上一篇
下一篇
ORA-04021(timeout occurred while waiting to lock)
作者:Sonic 日期:2009-07-07
某个应用正在锁定该表或者包
表：
select b.SID, b.SERIAL#, c.SQL_TEXT
from v$locked_object a, v$session b, v$sqlarea c
where a.SESSION_ID = b.SID
and b.SQL_ADDRESS = c.ADDRESS
and c.sql_text like '%table_name%'
包：
select B.SID, b.USERNAME, b.MACHINE
FROM V$ACCESS A, V$SESSION B
Where A.SID = B.SID
and a.OBJECT = '%PACKAGE_name%'
and a.TYPE = 'PACKAGE'
表：
复制内容到剪贴板
程序代码
程序代码select b.SID, b.SERIAL#, c.SQL_TEXT
from v$locked_object a, v$session b, v$sqlarea c
where a.SESSION_ID = b.SID
and b.SQL_ADDRESS = c.ADDRESS
and c.sql_text like '%table_name%'
包：
复制内容到剪贴板 程序代码
程序代码select B.SID, b.USERNAME, b.MACHINE
FROM V$ACCESS A, V$SESSION B
Where A.SID = B.SID
and a.OBJECT = '%PACKAGE_name%'
and a.TYPE = 'PACKAGE'
文章来自: 
引用通告: 
Tags: 
相关日志:
评论: 0 | 引用: 0 | 查看次数: -
发表评论