Property | Description |
---|---|
Parameter type |
String |
Syntax |
|
broker_description::=
|
|
type_clause::=
Indicates the broker type. This is a mandatory parameter. |
|
brokers_clause::=
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::=
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 |
Modifiable |
|
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:
DEDICATED brokers are used by the multiprocess and multithreaded Oracle features. See Oracle Database Concepts for more information about these features.
DEDICATED
brokers are also used when the USE_DEDICATED_BROKER
initialization parameter is set to true
. See "USE_DEDICATED_BROKER" for more information about the USE_DEDICATED_BROKER
initialization parameter.
EMON brokers are used when there is a client registered for notification over 12c AQ queues. It is not on by default. See Oracle Database Advanced Queuing User's Guide for more information about AQ queues.
POOLED brokers are used whenever a Database Resident Connection Pooling (DRCP) pool is active. See Oracle Database Concepts for more information about DRCP pooling.
The POOLED broker does not appear in the parameter by default. In this case, the DRCP fields are used. If you specify the POOLED
broker in the parameter, then that specification will override the DRCP fields, and further attempts to set the DRCP fields will then throw an error. Oracle recommends that the parameter be used instead of the DRCP fields.
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))'