Use this dialog box to edit the default values for the Shared Server parameters.
The fields on this dialog box correspond to the MAX_SHARED_SERVERS initialization parameter and the various arguments you can include as part of the DISPATCHERS initialization parameter.
For information about all the Oracle Database initialization parameters, see the Oracle Database Reference.
The following table describe the fields on the dialog box. The Advanced Options are described later in this topic.
| Element | Description |
|---|---|
| Maximum Shared Servers |
This parameter defaults to whichever is greater - 20, or two times the number of shared servers entered in the Shared Server field on the Connection Mode tab of the Initialization Parameters page. |
| Number of Dispatchers |
The initial number of dispatchers to start. Default is 1, if unspecified.
|
| Maximum Number of Connections Per Dispatcher | The maximum number of network connections to allow for each dispatcher. The default is operating-system specific. |
| Maximum Number Network Sessions | The maximum number of network sessions to allow for each dispatcher. The default is operating system-specific. Most operating systems have a default of 16 KB. |
| Service Name | The service names that the dispatchers register with the listeners. |
| Listeners with which the dispatchers will register |
Specifies the network name of an address or address list of the Oracle Net listeners with which the dispatchers will
register.
This attribute facilitates administration of multi-homed hosts. This attribute specifies the appropriate listeners with which the dispatchers will register. This attribute takes takes precedence over the LOCAL_LISTENER and REMOTE_LISTENER database initialization parameters.
|
When you click Advanced Options on the Edit Shared Server Parameters dialog box, you can set several additional dispatcher settings. These settings correspond to various arguments you can provide to the DISPATCHERS initialization parameter.
Use the drop-down list on the Edit Shared Server Parameters Advanced Options dialog box to enable session multiplexing for the Oracle Connection Manager. Session multiplexing allows you to combine multiple sessions for transmission over a single network connection in order to conserve the operating system's resources.
For more information about the Oracle Connection Manager and session multiplexing, see the Oracle Net Administrator's Guide.
The connection pooling feature enables the database server to timeout an idle session and use the connection to service an active session.
When you enable connection pooling, you must also define the timeout parameters. The timeouts are measured in ticks. You define the length of a tick by entering a number in the Tick Size (seconds) field.
A tick is the amount of time it takes for a message to be sent and processed from the client to the database server or from the database server to the client. The value set is multiplied with the connection pool timeout value to get the total connection pool timeout.
The default size of a tick is 1 second. For a fast network, such as a local area network (LAN), Oracle Corporation recommends a tick size of about one (1) second. For a slower network, such as a Wide Area Network (WAN), Oracle Corporation recommends a tick size of three to four (3-4) seconds.
After you specify the tick size, you can then enter the corresponding connection timeout for incoming and outgoing connections.
Copyright © 1996, 2011, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates.
Other names may be trademarks of their respective owners.