b1nary0mega
12/22/2015 - 5:06 PM

Find lock session on specific table and kill it.

Find lock session on specific table and kill it.

Find lock and kill session.sql
content_copyfile_download
SELECT OBJECT_ID FROM DBA_OBJECTS WHERE OBJECT_NAME = 'EMPLOYEE_PROFILE_UPLOAD';
--113339

SELECT SID FROM V$LOCK WHERE ID1=113339;
--1042

SELECT SID, SERIAL# FROM V$SESSION WHERE SID=1042;
--1042  32514

ALTER SYSTEM KILL SESSION '1042,32514';
--system KILL altered.