Month: November 2016

Show Unix PID ( v$process.spid ) of an Oracle process

SELECT s.inst_id, s.type, s.sid, s.serial#, p.spid, s.username, s.program FROM gv$session s, gv$process p where p.addr = s.paddr and p.inst_id = s.inst_id and s.type != ‘BACKGROUND’; — once you have the v$process.spid – you have the OS PID so – a command like this from the OS command line can also shed more light ps -ef …

Show Unix PID ( v$process.spid ) of an Oracle process Read More »