oracle的解除锁表

下面是oracle的解除锁表，用了很久，感觉不错，学习别人的

select l.session_id,o.owner,o.object_name
from v$locked_object l,dba_objects o
where l.object_id=o.object_id;

select s.username,s.sid,s.serial#,s.logon_time
from  v$locked_object l,v$session s
where l.session_id=s.sid 
order by s.logon_time;

--alter system kill session 'sid,serial#'
alter system kill session '2304,48667'

commit;