Skip to Main Content
Oracle Initialization Parameters Pocket Reference
book

Oracle Initialization Parameters Pocket Reference

by David C. Kreines
August 2004
Intermediate to advanced content levelIntermediate to advanced
122 pages
4h 22m
English
O'Reilly Media, Inc.
Content preview from Oracle Initialization Parameters Pocket Reference
DISPATCHERS
Parameter Quick Reference
|
39
Controls whether I/O to datafiles, control files, and log files is
asynchronous. If a platform does not support asynchronous I/O
to disk, this parameter has no effect. If DISK_ASYNCH_IO is set
to FALSE, the DBWR_IO_SLAVES parameter should be set to a
nonzero value in order to simulate asynchronous I/O.
DISPATCHERS
Value:
Quoted string (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
40
|
Oracle Initialization Parameters Pocket Reference
DISPATCHERS
Initial number of dispatchers.
SESSIONS
Maximum number of network sessions per dispatcher.
CONNECTIONS
Maximum number of network connections per dispatcher.
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

Running Applications on Oracle Exadata

Running Applications on Oracle Exadata

Joyjeet Banerjee

Publisher Resources

ISBN: 9780596528850