Posted on 2010-03-30 15:49
非洲小白脸 阅读(269)
评论(0) 编辑 收藏 所属分类:
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'