SQL QUERY TO IDENTIFY THE OS PID OR SPID

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';

Leave a Reply

%d bloggers like this: