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 | grep <whatever the SPID is >

Leave a Comment

Scroll to Top