Wednesday, July 9, 2014

Oracle: Find Oracle User Session ID with OS process id

SQL> select * from v$process;

SQL> SELECT a.sid, b.spid FROM v$session a, v$process b
WHERE a.paddr = b.addr
and b.spid = 10099;

No comments:

Post a Comment