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’;