oracle中用sql查询被锁的表与解锁方法

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;



alter system kill session 'sid,serlal#';