4.44 ALL_SAGA_BROKERS

ALL_SAGA_BROKERS displays the saga brokers accessible to the current user.

Related Views

  • 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 Database 23ai.

See Also: