Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from 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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page