Oracle DBMS_APP_CONT_PRVT
Version 19.3

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
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.0.3
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
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);
TBD

Related Topics
AS_REPLAY
Built-in Functions
Built-in Packages
DBMS_APP_CONT
DBMS_APP_CONT_ADMIN
DBMS_WORKLOAD_CAPTURE
DBMS_WORKLOAD_REPLAY
DBMS_WRR_INTERNAL
What's New In 18c
What's New In 19c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx