ALL_SAGA_PARTICIPANTS

ALL_SAGA_PARTICIPANTS describes the saga participants accessible to the current user.

This view displays sagas that were either initiated in the current PDB or joined by participants or coordinators in the current PDB.

Column Datatype NULL Description
ID RAW(16) NOT NULL ID of the saga participant
NAME VARCHAR2(128) NOT NULL Name of the saga participant
OWNER VARCHAR2(128) NOT NULL Owner of the saga participant
BROKER_NAME VARCHAR2(128) NOT NULL Name of the saga broker
TYPE VARCHAR2(50)  

Participant type:

  • Coordinator

  • Participant
COORDINATOR VARCHAR2(128)   Name of the saga coordinator
INCOMING_TOPIC VARCHAR2(128) NOT NULL Saga incoming topic
OUTGOING_TOPIC VARCHAR2(128) NOT NULL Saga outgoing topic
QUEUE_PARTITIONS NUMBER NOT NULL Number of saga topic partitions
QUEUE_TYPE VARCHAR2(13)  

Saga topic type:

  • Classic Queue

  • TxEvent Queue
LISTENER_COUNT VARCHAR2(40)  

Possible values:

  • AQ - The saga coordinator processes messages using the Advanced Queuing (AQ) notification mechanism.

  • AUTO - The saga coordinator processes messages using job queue processes that dequeue from the coordinator queue. This mechanism spawns a monitoring job that automatically adds and removes dequeuer jobs depending on the queue depth.

  • If this column displays a number value, then the value represents the number of fixed jobs that are created to process messages for the saga coordinator.
VERSION NUMBER NOT NULL Saga participant version

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

See Also: