Oracle DBMS_APP_CONT_PRVT
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
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
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 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
DBMS_APP_CONT
DBMS_WORKLOAD_CAPTURE
DBMS_WORKLOAD_REPLAY
DBMS_WRR_INTERNAL
Packages
What's New In 12cR1
What's New In 12cR2

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-2017 Daniel A. Morgan All Rights Reserved