Oracle锁表查询语句【备忘】

select t2.username,          t2.sid,          t2.serial#,          t3.object_name,          t2.OSUSER,          t2.MACHINE,          t2.PROGRAM,          t2.LOGON_TIME,          t2.COMMAND,          t2.LOCKWAIT,          t2.SADDR,          t2.PADDR,          t2.TADDR,          t2.SQL_ADDRESS,          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;  

?