1.锁表查询
--锁表查询 SELECT OBJECT_NAME AS TABLE_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;
2.解表
--释放SESSION SQL --ALTER SYSTEM KILL SESSION ‘sid, serial‘; ALTER SYSTEM KILL SESSION ‘1916, 19637‘;
3.效果展示
原文：https://www.cnblogs.com/Marydon20170307/p/8963586.html