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

Related Views

  • DBA_HIST_SAGAS provides a history of all completed sagas in the database.

  • USER_HIST_SAGAS provides a history of the completed sagas owned by the current user. This view does not display the OWNER column.

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

See Also: