Oracle9i Database Reference
Release 1 (9.0.1)

Part Number A90190-02
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

Initialization Parameters, 107 of 220


MTS_DISPATCHERS

Parameter type 

String 

Syntax 

MTS_DISPATCHERS = 'dispatch_clause' 

 

dispatch_clause::=

(PROTOCOL = protocol) |
(ADDRESS = address) |
(DESCRIPTION = description )
[options_clause]
 
 

options_clause::=

(DISPATCHERS = integer |
 SESSIONS = integer |
 CONNECTIONS = integer |
 TICKS = seconds |
 POOL = {1 | ON | YES | TRUE | BOTH |
   ({IN | OUT} = ticks) | 0 | OFF | NO | FALSE |
   ticks} | 
 MULTIPLEX = {1 | ON | YES | TRUE |
   0 | OFF | NO | FALSE | BOTH | IN | OUT} |
 LISTENER = tnsname |
 SERVICE = service |
 INDEX = integer)
 
Default value 

There is no default value. 

Parameter class 

Dynamic: ALTER SYSTEM 


Note:

This parameter is deprecated in favor of the DISPATCHERS parameter. Oracle recommends that you use DISPATCHERS instead. MTS_DISPATCHERSis retained for backward compatibility only. 


MTS_DISPATCHERS configures dispatcher processes in the multi-threaded server (MTS) architecture. The parsing software supports a name-value syntax to enable the specification of attributes in a position-independent case-insensitive manner. For example:

MTS_DISPATCHERS = "(PROTOCOL=TCP)(DISPATCHERS=3)"

Specify only one of the following attributes: PROTOCOL, ADDRESS, or DESCRIPTION. If you specify either ADDRESS or DESCRIPTION, you can specify additional network attributes. Doing so supports multi-homed hosts.

dispatch_clause

options_clause

POOL can also be assigned a name-value string such as: "(IN=10)", "(OUT=20)", or "(IN=10)(OUT=20)". In such cases:


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback