ALL_INCOMPLETE

3.235 ALL_INCOMPLETE_SAGAS

ALL_INCOMPLETE_SAGAS describes the incomplete 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.

Related Views

DBA_INCOMPLETE_SAGAS describes all incomplete sagas in the database.
USER_INCOMPLETE_SAGAS describes the incomplete 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: `Commit Failed` `Rollback Failed` `Timeout`
`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

Note:

This view is available starting with Oracle Database 23ai.