select p.SPID, p.SERIAL# as proserial,p.PID as pid, s.SID as sessionid,
s.SERIAL# as sessseri, s.USERNAME,s.OSUSER,s.MACHINE,
s.PROGRAM,s.ACTION,s.STATUS
from v$session s, v$process p
where s.PADDR=p.ADDR and s.SID in (select session_id from v$locked_object where object_id in (select object_id from dba_objects
where wner='&schema' and object_name='&name'));
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/35489/viewspace-748350/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
