[ 查看锁 ]
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';
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';