ALL_SAGA_FINALIZATION
ALL_SAGA_FINALIZATION displays information about pending finalization actions for sagas accessible to the current user.
This view displays one row for each unique reservable table updated as part of a participant transaction for sagas that were either initiated in the current PDB or joined by participants in the current PDB.
Related Views
-
DBA_SAGA_FINALIZATIONdisplays information about pending finalization actions for all sagas in the database. -
USER_SAGA_FINALIZATIONdisplays information about pending finalization actions for 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(32) |
ID of the reservable column transaction in the saga | |
RESERVABLE_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 |
VARCHAR2(55) |
Name of the reservable journal table involved in the transaction | |
STATUS |
VARCHAR2(15) |
<p>Status of the transaction: <ul id="GUID-4C825BE9-FD74-4725-869E-2B7403CA9355__UL_BGS_R43_FTB" style="list-style-type: disc;"> <li> Initiated - Participant transactions committed; saga not finalized </li> <li> Committed - Saga branch committed </li> <li> Rolledback - Saga branch rolled back </li> <li> Commit Failed - Saga branch commit failed </li> <li> Rollback Failed - Saga branch rollback failed </li> </ul> </p> |
Note: This view is available starting with Oracle AI Database 26ai.
See Also: