Oracle Manage Shared Server

1、server type: dedicate,shared
2、dedicate:client:server 1:1
3、listener create dedicate server for us (use fork exec in unix)
4、shared:dispatcher process,Shared server process
        one dispatcher server 250-300 client
5、data transfer:client->dispatcher ->requestqueue->shared server->dispatcher's responsequeue->dispatcher->client
6、init para:dispatchers,large_pool_size
7、lsnrctl services :查看已注册的dispatcher和dedicated server
8、tnsnames配置 server=shared|dedicated 显示指定连接方式 （default shared)

9、shared 模式主要用于c/s 2-Tier架构，j2ee等自己实现了连接池

 

 

数据字典：

v$circuit
v$shared_server
v$dispatcher
v$shared_server_monitor
v$queue
v$session