4.49 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.

Related Views

  • DBA_SAGA_PARTICIPANTS describes all saga participants in the database.

  • USER_SAGA_PARTICIPANTS describes the saga participants owned by the current user. This view does not display the OWNER column.

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

See Also: