4.47 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_FINALIZATION displays information about pending finalization actions for all sagas in the database.

  • USER_SAGA_FINALIZATION displays 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)

Status of the transaction:

  • Initiated - Participant transactions committed; saga not finalized

  • Committed - Saga branch committed

  • Rolledback - Saga branch rolled back

  • Commit Failed - Saga branch commit failed

  • Rollback Failed - Saga branch rollback failed

Note:

This view is available starting with Oracle Database 23ai.

See Also: