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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment