try:
select b.OBJECT_NAME,
a.ORACLE_USERNAME,
a.OS_USER_NAME,
a.PROCESS,
c.program,
c.terminal,
c.sid,
c.serial#
from V$LOCKED_OBJECT a ,DBA_OBJECTS b ,v$session c
where (a.OBJECT_ID=b.OBJECT_ID
and c.sid=a.session_id)
order by a.ORACLE_USERNAME,b.OBJECT_NAME;
select b.OBJECT_NAME,
a.ORACLE_USERNAME,
a.OS_USER_NAME,
a.PROCESS,
c.program,
c.terminal,
c.sid,
c.serial#
from V$LOCKED_OBJECT a ,DBA_OBJECTS b ,v$session c
where (a.OBJECT_ID=b.OBJECT_ID
and c.sid=a.session_id)
order by a.ORACLE_USERNAME,b.OBJECT_NAME;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货