===========================================================
oracle10g查看表锁和解锁
===========================================================
作者: kyle(http://kyle.itpub.net)
发表于: 2008.10.06 10:47
分类: dbms
出处: http://kyle.itpub.net/post/1626/471742
---------------------------------------------------------------
发表于: 2008.10.06 10:47
分类: dbms
出处: http://kyle.itpub.net/post/1626/471742
---------------------------------------------------------------
--查看锁
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;
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';
