SELECT OBJECT_NAME,MACHINE,S.SID,S.SERIAL# FROM V$LOCKED_OBJECT L,DBA_OBJECTS O,V$SESSION S WHERE L.OBJECT_ID = O.OBJECT_ID AND L.SESSION_ID = S.SID; ALTER SYSTEM KILL SESSION ‘SID,SERIAL#‘;
SELECT OBJECT_NAME,MACHINE,S.SID,S.SERIAL# FROM V$LOCKED_OBJECT L,DBA_OBJECTS O,V$SESSION S WHERE L.OBJECT_ID = O.OBJECT_ID AND L.SESSION_ID = S.SID; ALTER SYSTEM KILL SESSION ‘SID,SERIAL#‘;
