ALL_HIST_SAGAS

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