Oracle | DBMS_APP_CONT

Oracle DBMS_APP_CONT_PRVT Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

Purpose Internal support package for application continuity that allows an application to manage transaction monitoring and replay for select-only transactions.

AUTHID DEFINER

Dependencies

ALL_TAB_PARTITIONS	DBMS_APP_CONT_PRVT_LIB2	PLITBLM
DBMS_APP_CONT_PRVT_LIB

Documented No

First Available 11.2

Pragma PRAGMA SUPPLEMENTAL_LOG_DATA(default, NONE);

Security Model Owned by SYS with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/rdbms/admin/dbmsappcont.sql

Subprograms

BEGIN_REPLAY	MONITOR_TXN	PREPARE_REPLAY
END_REPLAY	PARTITION_EXISTS

BEGIN_REPLAY

Enables the replay mode in the server. While in replay mode, no transactions can be either started or committed dbms_app_cont_prvt.begin_replay;

exec dbms_app_cont_prvt.begin_replay;

END_REPLAY

Disables replay mode dbms_app_cont_prvt.end_replay;

exec dbms_app_cont_prvt.end_replay;

MONITOR_TXN

Enables the monitoring of transactions in the server dbms_app_cont_prvt.monitor_txn;

exec dbms_app_cont_prvt.monitor_txn;

PARTITION_EXISTS

Determines if a partition in the transaction history table exists dbms_app_cont_prvt.partition_exists(part_id IN NUMBER) RETURN NUMBER;

SELECT dbms_app_cont_prvt.partition_exists(42);

PREPARE_REPLAY

Asks server to check status of last action and prepare for a replay dbms_app_cont_prvt.prepare_replay( client_ltxid IN RAW, attempting_replay IN BOOLEAN, commit_on_success IN BOOLEAN, call_fncode IN BINARY_INTEGER, sql_text IN VARCHAR2, committed OUT BOOLEAN, embedded OUT BOOLEAN, signature_flags IN NUMBER := NULL, client_signature IN NUMBER := NULL, server_signature IN NUMBER := NULL, signature_version IN NUMBER := 0);

TBD