--查看 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‘;
原文：http://www.cnblogs.com/weixiaojun/p/5032856.html