锁表查询SQL:
SELECT object_name,machine,s.sid,s.serial#
FROM gv$locked_object l,Dba_Objects o,gv$session s
WHERE l.OBJECT_ID = o.object_id
AND l.SESSION_ID = s.SID;
找到被锁定的表,解锁(session 'sid,serial#'):
ALTER SYSTEM KILL SESSION '3791,12093';
锁表查询SQL:
SELECT object_name,machine,s.sid,s.serial#
FROM gv$locked_object l,Dba_Objects o,gv$session s
WHERE l.OBJECT_ID = o.object_id
AND l.SESSION_ID = s.SID;
找到被锁定的表,解锁(session 'sid,serial#'):
ALTER SYSTEM KILL SESSION '3791,12093';
转载于:https://my.oschina.net/u/3891918/blog/1858286