select
t2.username,t2.sid,t2.serial#,t2.logon_time,t2.OSUSER,t2.PROGRAM,t3.OBJECT,t3.TYPE
from v$session t2,v$locked_object t1,v$access t3 where
t3.OWNER=t2.USERNAME and t2.SID=t1.SESSION_ID and
t2.SID=t3.SID;
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/11754813/viewspace-586718/
,如需转载,请注明出处,否则将追究法律责任。