SELECT s.sid,
l.lock_type,
l.mode_held,
l.mode_requested,
l.lock_id1,
‘alter system kill session ”’|| s.sid|| ‘,’|| s.serial#|| ”’ immediate;’ kill_sid
FROM dba_lock_internal l,
v$session s
WHERE s.sid = l.session_id
AND UPPER(UPPER(l.lock_id1)) LIKE ‘%NOME_DO_OBJETO%’;
SELECT DISTINCT ‘alter system kill session ‘|| s.sid||’ ‘||s.serial#||’ immediate;’ kill_sid
/*,s.*
,l.*
,v.**/
FROM dba_lock_internal l
,v$session s
,(SELECT *
FROM v$lock
WHERE id1 = (SELECT object_id
FROM dba_objects
WHERE owner = owner
AND object_name = ‘NOME_DA_TABELA’)) v
WHERE s.sid = l.session_id
AND s.sid = v.sid
select *
from v$lock
where id1 = (
select object_id
from dba_objects
where owner = owner — Change the owner according to your env.
and object_name = ‘NOME_DA_TABELA’ — Change the Table name as per your use case.
);