select substr(o.object_name,1,25)  objeto,
       l.session_id                     session_id,
       l.oracle_username                ora_user,
       l.os_user_name                   os_user
from   dba_objects o, gv$locked_object l
where  l.object_id = o.object_id
order by 1,3,4;
 
select sid, SERIAL#, USERNAME, status  from v$session where sid  = 16438;

alter system kill session '16438, 5509' immediate;

SELECT p.INST_ID, p.pid, p.serial#, p.spid, p.program
 FROM gv$process p
 WHERE p.spid is not null
 AND NOT EXISTS (SELECT 1 FROM gv$session s WHERE s.inst_id = p.inst_id and s.paddr = p.addr)
 AND p.pname is null
 ORDER BY p.inst_id
 /