Oracle in a Nutshell

Name

DISPATCHERS

Synopsis

Value: see description

Default: none

Dynamic: ALTER SYSTEM

Configures dispatcher processes in a Shared Server environment. New with Oracle9i.

Syntax

DISPATCHERS =
'{ (PROTOCOL = protocol)
 | (ADDRESS = address)
 | (DESCRIPTION = description}
}
[({DISPATCHERS = integer
  | SESSIONS = integer
  | CONNECTIONS = integer 
  | TICKS = seconds
  | POOL = {1 | ON | YES | TRUE | BOTH |({IN | OUT} = integer) | 
            0 | OFF | NO | FALSE | integer}    
| MULTIPLEX = {1 | ON | YES | TRUE |                  
               0 | OFF | NO | FALSE | BOTH | IN | OUT}   
| LISTENER = tnsname
| SERVICE = service
| INDEX = integer
})]'

Keywords

protocol

Network protocol for the dispatcher.

address

Network protocol address for the dispatcher.

description

Network description for the dispatcher.

DISPATCHERS

Initial number of dispatchers.

SESSIONS

Maximum number of network sessions per dispatcher.

CONNECTIONS

Maximum number of network connections per dispatcher.

TICKS

Length of a network tick in seconds.

POOL

Controls connection pooling. ON, YES, TRUE, and BOTH specify connection pooling for IN and OUT network connections. NO, OFF, and FALSE specify no connection pooling for IN and OUT network connections. IN and OUT specify connection pooling for their respective network connections. An integer by itself indicates the timeout for both types of connections. You can include an integer with IN or OUT, such as (IN = 20)(OUT = 10), to specify the ticks for each direction. The default timout is 10.

MULTIPLEX

Enables network session multiplexing for both IN ...