Configuring Oracle Database for Shared Server

Steps
Initialization Parameters for Shared Server
Memory Management for Shared Server
Enabling Shared Server
Configuring Dispatchers
Disabling Shared Server
Shared Server Data Dictionary Views

Initialization Parameters
SHARED_SERVERS (required)
MAX_SHARED_SERVERS
SHARED_SERVER_SESSIONS
DISPATCHERS
MAX_DISPATCHERS
CIRCUITS


Configuring SHARED_SERVERS in PFILE
Configuring either SHARED_SERVERS or DISPATCHERS greate than 0 enable shared server

Configuring Dispatchers in PFILE
dispatchers="(PROTOCOL=tcp)"


DISABLE SHARED SERVER
SQL>ALTER SYSTEM SET SHARED_SERVER=0
SQL>ALTER SYSTEM SET DISPATCHERS=‘‘;

如何连接和检查Shared Server连接状态?