The Fei's Tech Notes
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
‹
›
Home
View web version
No comments:
Post a Comment