Oracle | DBMS_CAPTURE

Oracle DBMS_CAPTURE_PROCESS Version 21c

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 Support for Log Mining and transaction capture.

AUTHID DEFINER

Dependencies

DBMS_CAPTURE_ADM_INTERNAL	DBMS_SYS_ERROR	V$ARCHIVED_LOG
DBMS_LOGMNR_SESSION_INT	LOGMNR_BUILDLOG	V$CONTAINERS
DBMS_LOGREP_UTIL	LOGMNR_LOG$	V$DATABASE
DBMS_STANDARD	LOGMNR_RESTART_CKPT$	V$LOG
DBMS_SYSTEM	STREAMS$_CAPTURE_PROCESS	V$LOGFILE

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	GET_CAPTURE#	WAIT_FOR_DICTIONARY_DUMP
CLONE_LOGMNR_SESSION_CKPTFRE	IS_DICTIONARY_MINED

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