不提示错误嘛,就是一直等待! 感觉很郁闷,不像死锁啊!select a.SID,a.SERIAL#,a.USERNAME from sys.v_$session a,sys.dba_objects b,v$locked_object c where b.object_id = c.OBJECT_ID and a.SID = c.SESSION_ID and b.object_name = 'dcyundanhao'这个样子查询不出结果集!
select * from v$lock a,v$session b,v$sql c where a.SID=b.SID and nvl(b.SQL_HASH_VALUE,b.PREV_HASH_VALUE)=c.HASH_VALUE and lower(c.SQL_TEXT) like '%表名%'; 这样看有数据么
感觉很郁闷,不像死锁啊!select a.SID,a.SERIAL#,a.USERNAME
from sys.v_$session a,sys.dba_objects b,v$locked_object c
where b.object_id = c.OBJECT_ID
and a.SID = c.SESSION_ID
and b.object_name = 'dcyundanhao'这个样子查询不出结果集!
where a.SID=b.SID
and nvl(b.SQL_HASH_VALUE,b.PREV_HASH_VALUE)=c.HASH_VALUE
and lower(c.SQL_TEXT) like '%表名%';
这样看有数据么