查看锁定
select t2.username,
t3.owner,
t3.object_name,
t2.machine,
t2.sid as sid,
t2.serial#,
t2.LAST_CALL_ET,
t2.program,
t1.locked_mode
from v$locked_object t1, v$session t2, dba_objects t3
where t1.session_id = t2.sid
and t1.OBJECT_ID = t3.object_id
order by t2.logon_time;