Remove Oracle Table Lock

1. Run the following to get session id of locked table.

     SELECT SESSION_ID 

     FROM DBA_DML_LOCKS 

     WHERE NAME = 'Table Name';

  2. Use this session id to find SERIAL# by using following SELECT statment

     SELECT SID,SERIAL# 
     FROM V$SESSION 
     WHERE SID IN (SELECT SESSION_ID 
     FROM DBA_DML_LOCKS 
     WHERE NAME = 'Table Name');

     3.  Use ALTER SYSTEM command to KILL SESSION and this will release the lock:

     ALTER SYSTEM KILL SESSION 'SID,SERIALl#';