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;
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博客 ” ，链接：https://blog.itpub.net/29812751/viewspace-1809101/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
