select *
from v$lock
where id1 = (
select object_id
from dba_objects
where owner = 'XXCUS'
and object_name = 'TEMP_JE_DETAILS_K_GLOBAL'
);
ALTER SYSTEM KILL SESSION '265,2978';
SELECT s.inst_id,
s.sid,
s.serial#,
p.spid,
s.username,
s.program
FROM gv$session s
JOIN gv$process p ON p.addr = s.paddr AND p.inst_id = s.inst_id
WHERE s.type != 'BACKGROUND' and s.sid =265 ;
from v$lock
where id1 = (
select object_id
from dba_objects
where owner = 'XXCUS'
and object_name = 'TEMP_JE_DETAILS_K_GLOBAL'
);
ALTER SYSTEM KILL SESSION '265,2978';
SELECT s.inst_id,
s.sid,
s.serial#,
p.spid,
s.username,
s.program
FROM gv$session s
JOIN gv$process p ON p.addr = s.paddr AND p.inst_id = s.inst_id
WHERE s.type != 'BACKGROUND' and s.sid =265 ;