查看某表正在被用户使用，连接

select s.*
from v$locked_object l, dba_objects o, v$session s, v$process p
where l.object_id = o.object_id
and l.session_id = s.sid
and s.paddr = p.addr
AND object_name='SM_MMS_MTDB';


select object_name,machine,s.sid,s.serial# from gv$locked_object l,SYS.DBA_OBJECTS o,
gv$session s where l.OBJECT_ID=o.OBJECT_ID and l.SESSION_ID=s.sid;

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

转载于:http://blog.itpub.net/29812751/viewspace-1809101/