Configuring Oracle Database for Shared Server

You can enable shared server and set or alter shared server initialization parameters.

• Initialization Parameters for Shared Server
  A set of initialization parameters control shared server operation.

Microsoft 365 certification training courses malaysia

• Memory Management for Shared Server
  Shared server requires some user global area (UGA) in either the shared pool or large pool. For installations with a small number of simultaneous sessions, the default sizes for these system global area (SGA) components are generally sufficient. However, if you expect a large number of sessions for your installation, you may have to tune memory to support shared server.
• Enabling Shared Server
  Shared server is enabled by setting the SHARED_SERVERS initialization parameter to a value greater than 0. The other shared server initialization parameters need not be set.

lpi Linux administration certification training courses malaysia

• Configuring Dispatchers
  The DISPATCHERS initialization parameter configures dispatcher processes in the shared server architecture. At least one dispatcher process is required for shared server to work. If you do not specify a dispatcher, but you enable shared server by setting SHARED_SERVER to a nonzero value, then by default Oracle Database creates one dispatcher for the TCP protocol.

lean six sigma certification training courses malaysia

• Disabling Shared Server
  You disable shared server by setting the SHARED_SERVERS initialization parameter to 0. You can do this dynamically with the ALTER SYSTEM statement.
• Shared Server Data Dictionary Views
  You can query data dictionary views for information about your shared server configuration and to monitor performance.

application services