SQL QUERY TO IDENTIFY THE OS PID OR SPID
There is often
kIsH@xHydra<>set lines 200 pages 1000
kIsH@xHydra<>col USERNAME for a20
kIsH@xHydra<>SELECT s.username,s.sid,s.serial#,s.program,p.spid
FROM v$process p
INNER JOIN v$session s
ON (s.paddr = p.addr)
WHERE s.username='SYS';