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

See Also: