ALL_SAGA_PENDING
ALL_SAGA_PENDING describes the pending sagas accessible to the current user.
This view displays sagas that were initiated in the current PDB.
Related Views
-
DBA_SAGA_PENDINGdescribes all pending sagas in the database. -
USER_SAGA_PENDINGdescribes the pending sagas owned by the current user.
| Column | Datatype | NULL | Description |
|---|---|---|---|
SAGA_ID |
RAW(16) |
NOT NULL |
Saga ID |
PARTICIPANT |
VARCHAR2(128) |
Name of the saga participant | |
TXN_ID |
VARCHAR2(16) |
ID of the reservable column transaction in the saga | |
SCHEMA |
VARCHAR2(128) |
NOT NULL |
Schema of the reservable column table involved in the transaction |
RESERVABLE_TABLE |
VARCHAR2(128) |
NOT NULL |
Name of the reservable column table involved in the transaction |
RESERVABLE_JOURNAL_STATUS |
VARCHAR2(12) |
Status of the transaction in the reservable journal table | |
STATEMENT_TYPE |
VARCHAR2(16) |
SQL statement type (for example, UPDATE or MERGE) |
|
OPERATION_TYPE |
VARCHAR2(16) |
NOT NULL |
Type of saga operation (for example, commit, rollback, or timeout) |
PRIMARYKEY_INFO |
CLOB |
NOT NULL |
Primary key and its value in the row whose reservable column value was updated in this transaction |
RESERVABLE_COL_INFO |
CLOB |
NOT NULL |
Reservable column value update information in this transaction |
Note: This view is available starting with Oracle AI Database 26ai.
See Also: