上海进博会_介绍自己公司的范文_淘宝推广软件哪个好_广州抖音seo

--查询锁
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';