JavaScript must be enabled to correctly display this content

ALL_SAGA_BROKERS

ALL_SAGA_BROKERS displays the saga brokers accessible to the current user.

DBA_SAGA_BROKERS displays all saga brokers in the database.
USER_SAGA_BROKERS displays the saga brokers owned by the current user.

Column	Datatype	NULL	Description
`ID`	`RAW(16)`	`NOT NULL`	ID of the saga broker
`NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the saga broker
`OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the saga broker
`BROKER_TOPIC`	`VARCHAR2(128)`		Name of the queue used by the broker
`REMOTE`	`VARCHAR2(50)`		Indicates whether the saga broker is remote (`TRUE`) or not (`FALSE`)
`VERSION`	`NUMBER`	`NOT NULL`	Saga broker version
`QUEUE_PARTITIONS`	`NUMBER`	`NOT NULL`	Controls the degree of parallelism of the broker For `Classic` `Queue` based brokers, the number of queues created For `TxEvent` `Queue` based brokers, the number of internal partitions
`QUEUE_TYPE`	`VARCHAR2(13)`		Saga topic type: `Classic` `Queue` `TxEvent` `Queue`

Note: This view is available starting with Oracle AI Database 26ai.

See Also:

“DBA_SAGA_BROKERS”
“USER_SAGA_BROKERS”