GET PID for SID

SELECT P.SPID, S.SID, S.SERIAL# FROM V$PROCESS P, V$SESSION S WHERE P.ADDR = S.PADDR AND S.SID = 405; col “SID/SERIAL” format a10 col username format a15 col osuser format a15 col program format a40 select     s.sid || ‘,’ || s.serial# “SID/SERIAL” ,     s.username ,     s.osuser ,     p.spid “OS PID” ,     s.program from     v$session s ,     v$process…

Session locks

set serveroutput on BEGIN    dbms_output.enable(1000000);   for do_loop in (select session_id, a.object_id, xidsqn, oracle_username, b.owner owner,    b.object_name object_name, b.object_type object_type   FROM v$locked_object a, dba_objects b     WHERE xidsqn != 0     and b.object_id = a.object_id)    loop    dbms_output.put_line(‘.’);   dbms_output.put_line(‘Blocking Session : ‘||do_loop.session_id);   dbms_output.put_line(‘Object (Owner/Name): ‘||do_loop.owner||’.’||do_loop.object_name);   dbms_output.put_line(‘Object Type :…