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.objec……
[/Quote]
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'