ORACLE培训资料Less13.pptVIP

Oracle Shared Servers Objectives After completing this lesson you should be able to do the following: Identify when to use Oracle Shared Servers Configure Oracle Shared Servers Monitor Shared Servers Establishing a Connection Dedicated Server Process User Sessions User Sessions: Dedicated Server User Sessions: Shared Server Processing a Request The SGA and PGA Configuring Oracle Shared Server Required parameter DISPATCHERS DISPATCHERS Specifies the number of dispatchers that are initially started for a given protocol. SHARED_SERVERS Specifies the number of shared server processes created when an instance is started up, and retained during instance operation. MAX_SHARED_SERVERS Specifies the maximum number of shared servers that can be started Allows shared servers to be allocated dynamically based on the length of the request queue CIRCUITS Specifies the total number of virtual circuits that are available for inbound and outbound network sessions Contributes to total SGA size SHARED_SERVER_SESSIONS Specifies the total number of Oracle Shared Server user sessions to allow Enables you to reserve user sessions for dedicated servers Related Parameters Other initialization parameters affected by Oracle Shared Server that may require adjustment: LARGE_POOL_SIZE SESSIONS PROCESSES LOCAL_LISTENER Verifying Shared Server Setup Verify that the dispatcher has registered with the listener when the database was started by issuing: Verify that you are connected using shared servers by making a connection and then query V$CIRCUIT view to show one entry per shared server connection. Data Dictionary Views V$CIRCUIT V$SHARED_SERVER V$DISPATCHER V$SHARED_SERVER_MONITOR V$QUEUE V$SESSION Choosing a Connection Type Unless otherwise configured, Oracle Net connections will use: Shared server if one is available Dedicated server if a shared server connection is not available Using local or directory naming, the connection type can be specified as part of the Net service alias. When