4.51 ALL_SAGAS

ALL_SAGAS describes the active 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_SAGAS describes all active sagas in the database.

  • USER_SAGAS describes the active 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(14)

Saga status:

  • New

  • Joining

  • Initiated

  • Joined

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 displays active sagas. Completed sagas are displayed in the ALL_HIST_SAGAS view.

Note:

This view is available starting with Oracle Database 23ai.

See Also: