SQL> select a.spid dedicated_server
2           ,b.process clintpid
3     from v$process a,v$session b
4 where a.addr = b.paddr
5      and b.audsid = userenv('sessionid');

DEDICATED_SERVER CLINTPID
------------------------ ----------------------
3504 3016:4500

这里3016是客户process,4500是threadid:

C:\Documents and Settings>tasklist /FI "PID eq 3016"
Image Name PID Session Name Session# Mem Usage
========================= ====== ================ ======== ============
sqlplus.exe 3016 Console 0 180 K

同样3504这里是oracle process的threadid;

ITPub博客

windows下server process 和client process(Deciated mode)

最新文章