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 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';于: 2008.10.06 10:47
分类: dbms
出处: http://kyle.itpub.net/post/1626/471742
---------------------------------------------------------------

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/20595629/viewspace-683359/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/20595629/viewspace-683359/