4.50 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_PENDING describes all pending sagas in the database.

• USER_SAGA_PENDING describes 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 Database 23ai.

See Also:

• "DBA_SAGA_PENDING"

• "USER_SAGA_PENDING"