ALL_SAGA_PARTICIPANT_SET

ALL_SAGA_PARTICIPANT_SET displays information about saga participants for sagas accessible to the current user.

Column Datatype NULL Description
ID RAW(16) NOT NULL Saga ID
COORDINATOR VARCHAR2(128) NOT NULL Name of the saga coordinator
PARTICIPANT VARCHAR2(128) NOT NULL Name of the saga participant
STATUS VARCHAR2(57)  

Saga status:

  • Joined

  • Committed

  • Rolledback

  • Commit Failed

  • Rollback Failed

  • Rejected

  • Auto Committed

  • Auto Rolledback
JOIN_TIME TIMESTAMP(6) WITH TIME ZONE   Join time of the saga participant
COMPLETION_TIME TIMESTAMP(6) WITH TIME ZONE   Completion time of the saga participant

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

See Also: