Delete Oracle Table DML lock

Commands:

SELECT SESSION_ID 
FROM DBA_DML_LOCKS 
WHERE NAME = Table Name;


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

ALTER SYSTEM KILL SESSION 'SID,SERIALl#';

Example:

 

SELECT SESSION_ID

FROM DBA_DML_LOCKS
WHERE NAME = ‘EPUB_DEPLOYMENT’;

SELECT SID,SERIAL#
FROM V$SESSION
WHERE SID IN (SELECT SESSION_ID
FROM DBA_DML_LOCKS
WHERE NAME = ‘EPUB_DEPLOYMENT’)

ALTER SYSTEM KILL SESSION ‘37,40724’;