4.48 ALL_SAGA_PARTICIPANT_SET

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

Related Views

  • DBA_INCOMPLETE_SAGAS displays information about saga participants for all sagas in the database.

  • USER_SAGA_PARTICIPANT_SET displays information about saga participants for sagas owned by 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 Database 23ai.

See Also: