Oracle锁表问题处理
--查询锁
SELECT s.sid, s.serial#, s.username, s.osuser, l.type, l.lmode, l.request
FROM v$session s
JOIN v$lock l ON s.sid = l.sid
WHERE l.id1 = (SELECT object_id FROM all_objects WHERE object_name = 'DESIGNER_PROC_BASE');--表明
--强制释放：ID + serial
ALTER SYSTEM KILL SESSION '18,34851';
ALTER SYSTEM KILL SESSION '4745,58695';
ALTER SYSTEM KILL SESSION '2862,27801';
ALTER SYSTEM KILL SESSION '2888,25835';
ALTER SYSTEM KILL SESSION '5665,18947';
ALTER SYSTEM KILL SESSION '18,34851';