Oracle DBMS_CAPTURE_PROCESS
Version 18.3.0.1

General Information
Library Note Morgan's Library Page Header
For how many years have you been working with physical servers that are starving your database of the memory necessary to deploy important new performance features such as the Result Cache, Memoptimize Pool, In-Memory Aggregation, In-Memory Column Store, and Full Database Caching? Too long? Contact me to learn how to improve all queries ... not just some queries.
Purpose Support for Log Mining and transaction capture.
AUTHID DEFINER
Dependencies
DBMS_CAPTURE_ADM_INTERNAL DBMS_SYSTEM STREAMS$_CAPTURE_PROCESS
DBMS_LOGMNR_SESSION_INT DBMS_SYS_ERROR V$ARCHIVED_LOG
DBMS_LOGREP_UTIL LOGMNR_LOG$ V$DATABASE
DBMS_STANDARD LOGMNR_RESTART_CKPT$  
Documented No
First Available Not Known
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/prvthcap.plb
Subprograms
 
CLONE_LOGMNR_SESSION
Clones a log miner session dbms_capture_process.clone_logmnr_session(
canon_qowner       IN  VARCHAR2,
canon_qname        IN  VARCHAR2,
canon_src_dbname   IN  VARCHAR2,
canon_capture_name IN  VARCHAR2,
start_scn          IN  NUMBER,
clone_appstate_cap IN  NUMBER,
FIRST_SCN          OUT NUMBER,
cloned_sess        OUT NUMBER,
orig_oldest_scn    OUT NUMBER,
canon_flags        IN  NUMBER,
share_sid          IN  NUMBER);
TBD
 
CLONE_LOGMNR_SESSION_CKPTFRE
Clones a log miner session dbms_capture_process.clone_logmnr_session_ckptfre(
canon_qowner       IN  VARCHAR2,
canon_qname        IN  VARCHAR2,
canon_src_dbname   IN  VARCHAR2,
canon_capture_name IN  VARCHAR2,
s_scn              IN  NUMBER,
f_scn              OUT NUMBER,
cloned_sess        OUT NUMBER,
orig_oldest_scn    OUT NUMBER,
canon_flags        IN  NUMBER,
share_sid          IN  NUMBER);
TBD
 
GET_CAPTURE#
Returns the capture id corresponding to a capture name dbms_capture_process.get_capture#(canon_capture_name IN VARCHAR2)
RETURN BINARY_INTEGER;
TBD
 
IS_DICTIONARY_MINED
Outputs a status indicating whether the data dictionary is being mined by the session dbms_capture_process.is_dictionary_mined(
logminer_sid IN  NUMBER,
status       OUT NUMBER);
TBD
 
WAIT_FOR_DICTIONARY_DUMP
Undocumented dbms_capture_process.wait_for_dictionary_dump(
canon_capture_name IN  VARCHAR2,
logminer_sid       IN  NUMBER,
first_scn          IN  NUMBER,
downstream_cap     IN  NUMBER,
end_scn            OUT NUMBER,
status             OUT NUMBER,
missing_log_info   OUT VARCHAR2);
TBD

Related Topics
Built-in Functions
Built-in Packages
DBMS_LOGMNR
DBMS_LOGMNR_D
What's New In 18cR3
What's New In 19cR3

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