CONNECTION_BROKERS

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.

Property	Description
Parameter type	String
Syntax	`CONNECTION_BROKERS =` `broker_description` `[, broker_description ] ...`
Syntax	`broker_description::=` `((type_clause)(brokers_clause)[(broker_options)])`
Syntax	`type_clause::=` `TYPE={ DEDICATED \| EMON \| POOLED }` Indicates the broker type. This is a mandatory parameter.
Syntax	`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.
Syntax	`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` and `EMON` broker types. 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`
Modifiable in a PDB	No
Basic	No
Oracle RAC	The same value should be set on all instances

The connection brokers are used in these cases:

DEDICATED brokers are used by the multiprocess and multithreaded Oracle features. See Oracle AI 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 AI Database Transactional Event Queues and 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 AI 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))'