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_SAGASdescribes all active sagas in the database. -
USER_SAGASdescribes the active sagas owned by the current user. This view does not display theOWNERcolumn.
| 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:
|
|
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:
|
|
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 AI Database 26ai.
See Also: