Oracle查看锁表与解锁方法

--查看

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 wherea.object_id=b.object_id andc.sid=b.session_id;

--解锁

alter system kill session'session_id,serial#';

--例句

alter system kill session'453,10316';