SQL to Identify/Remove Locked Objects in Oracle

The Following SQL Script is used to finds the locked Objects in Oracle.

---------------------- SQL to find SID and Serial# number ---------------
-----------------------------------------------------------------------------------
SELECT C.OWNER,
       C.OBJECT_NAME,
       C.OBJECT_TYPE,
       B.SID,
       B.SERIAL#,
       B.STATUS,
       B.OSUSER,
       B.MACHINE
  FROM V$LOCKED_OBJECT A, V$SESSION B, DBA_OBJECTS C
 WHERE B.SID = A.SESSION_ID AND A.OBJECT_ID = C.OBJECT_ID;

-----------------------------------------------------------------------------------

Once we have identified the locked objects, the below script will help us to removes the lock of the objects. Here we need to provide the SID and SERIAL# values from the above query.

---------------------------------- SQL to Kill session ------------------------
-----------------------------------------------------------------------------------
   ALTER SYSTEM KILL SESSION 'SID,SERIAL#';

-----------------------------------------------------------------------------------