oracle查锁解锁

select b.username,b.sid,b.serial#,logon_time,c.object_name
from v$locked_object a,v$session b,dba_objects c
where a.session_id = b.sid
and c.object_id = a.object_id
order by b.logon_time

 

alter system kill session '580,17275';