--查看
select
a.object_name,b.session_id,c.serial#,c.program,c.username,c.command,c.machine,c.lockwait
from
all_objects a,v$locked_object b,v$session c
where
a.object_id=b.object_id
and
c.sid=b.session_id;
--解锁
alter
system kill session
'session_id,serial#'
;
--例句
alter
system kill session
'453,10316'
;
