Oracle | DBMS_APP_CONT

Oracle DBMS_APP_CONT_PRVT Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

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)

      FROM dual;

PREPARE_REPLAY (4 new 21c parameters)

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