Skip Headers
Oracle® Database Reference
12c Release 1 (12.1)

E17615-24
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

CONNECTION_BROKERS

Property Description
Parameter type String
Syntax CONNECTION_BROKERS = broker_description[,...]
  broker_description::=

((type_clause)(brokers_clause)[(broker_options)])

  type_clause::=

TYPE={ DEDICATED | POOLED }

Indicates the broker type. This is a mandatory parameter.

  brokers_clause::=

BROKERS=integer

Indicates the number of brokers of the specified type. This is a mandatory parameter. The specified integer value must be greater than or equal to 0. If set to 0, brokers will not accept new connections, but existing connections will continue as normal.

  broker_options::=

CONNECTIONS=integer

The maximum number of connections per broker. This is an optional parameter. If the specified integer value is greater than the maximum allowed for the platform, the maximum allowed for the platform is used.

Default value The default value for the initialization parameter will contain the DEDICATED broker type. Certain types of brokers are only started when certain features are enabled, so their configuration will only apply if the broker is needed.
Modifiable ALTER SYSTEM
Basic No
Oracle RAC The same value should be set on all instances

CONNECTION_BROKERS is used to specify connection broker types, the number of connection brokers of each type, and the maximum number of connections per broker.

The connection brokers are used in these cases:

To make it easier to modify the list, individual entries are indexed using the TYPE so it is not necessary to re-specify the entire list. For example, to adjust the number of DEDICATED brokers:

alter system set connection_brokers = '((TYPE=DEDICATED)(BROKERS=2))'