oracle share server mode

共享模式下，

查看当前session，使用dispatcher和shared_server的方法

 

SQL:

 

select d.name ,s.name

from v$dispatcher d, v$shared_server s, v$circuit c

where d.paddr=c.dispather and s.paddr=c.server;

 

Result DATA:

 

Name    Name

--------   ---------

D000     S000

Configuration of shared_server mode:

 

1. local_listener=ocp11g -- TNS of dynamic register instance

2. dispatchers='(pro=TCP)(dis=2)' -- protocal : TCP and num of dispatcher : 2

3. shared_servers=4 -- num of shared_server : 4

 

Lookup for the dispatcher and shared_server process

 

SQL

select program from v$process order by program;

 

Result DATA:

you will find them

program

------------

ORACLE.EXE(D000)

ORACLE.EXE(D001)

ORACLE.EXE(S000)

ORACLE.EXE(S001)

ORACLE.EXE(S002)

ORACLE.EXE(S003)