最初由 whl93 发布
[B]还是有些不明白
SELECT server FROM v$session;
用这个时显示DEDICATED,这应该是专用服务器配置吧
而以下显示的结果如看服务器配置信息
oracle>lsnrctl service;
select * from v$shared_server; [/B]
1、如果全为DEDICATE则为专用服务器配置,如果有一个session的此值为SHARED,则就是SHARED SERVER方式。
2、oracle>lsnrctl service 如果显示的列表有些长,其中含有D000,D001... S000,S00或是类似如下,则为SHARED SERVER方式
DISPATCHER established:1 refused:0 current:2 max:254 state:ready
D000
(ADDRESS=(PROTOCOL=tcp)(HOST=test223)(PORT=32768))
PLSExtProc has 1 service handler(s)
DEDICATED SERVER established:0 refused:0
LOCAL SERVER
ora8test has 1 service handler(s)
DEDICATED SERVER established:1 refused:0
LOCAL SERVER
ora8test has 3 service handler(s)
DISPATCHER established:0 refused:0 current:0 max:254 state:ready
D001
... ...
3、select * from v$shared_server;有结果返回则为shared server方式,如果一行都没有,则为DEDICATED方式。