--根据sessionid 查询操作系统进程
sys@ORCLDEV> select a.spid dedicated_server, b.process clientId
2 from v$process a , v$session b
3 where a.addr = b.paddr
4 and b.audsid = userenv('sessionid');
DEDICATED_SE CLIENTID
------------ ------------
6559 6556
[bglbj2][oracle][/home/oracle]>ps -ef | grep 6559
oracle 6559 6556 0 07:49 ? 00:00:00 oracleorcldev (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 6937 6859 0 08:21 pts/2 00:00:00 grep 6559
[bglbj2][oracle][/home/oracle]>
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7551038/viewspace-616483/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/7551038/viewspace-616483/