ALL_HIST_SAGAS

ALL_HIST_SAGAS provides a history of the completed sagas accessible to the current user.

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

Completed sagas are retained in this view for the length of time specified by the SAGA_HIST_RETENTION initialization parameter. The default is 30 days.

Column Datatype NULL Description
ID RAW(16) NOT NULL Saga ID
INITIATOR VARCHAR2(128)   Name of the saga initiator
IS_INITIATOR VARCHAR2(3)   Indicates whether this participant is the saga initiator (YES) or not (NO)
COORDINATOR VARCHAR2(128)   Name of the saga coordinator
COORDINATOR_TYPE VARCHAR2(50)  

Type of the saga coordinator:

  • Internal

  • External
OWNER VARCHAR2(128) NOT NULL Owner of the saga participant
PARTICIPANT VARCHAR2(128) NOT NULL Name of the saga participant
STATUS VARCHAR2(15)  

Saga status:

  • Auto Committed

  • Auto Rolledback

  • Committed

  • Finalization

  • Rejected

  • Rolledback
VERSION NUMBER NOT NULL Saga version
DURATION NUMBER   Time limit for the saga (in seconds)
START_TIME TIMESTAMP(6) WITH TIME ZONE   Saga start time
FINALIZATION_TIME TIMESTAMP(6) WITH TIME ZONE   Time at which the saga finalization was initiated
COMPLETION_TIME TIMESTAMP(6) WITH TIME ZONE   Time at which the saga was marked as completed, that is, all saga participants responded to the finalization request

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

See Also: