Oracle DBMS_CAPTURE_SWITCH_INTERNAL
Version 18.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 transaction capture process modification related utilities.
AUTHID DEFINER
Dependencies
DBA_APPLY DBMS_LOGREP_UTIL STREAMS$_APPLY_SPILL_TXN
DBA_CAPTURE DBMS_STREAMS_ADM_UTL STREAMS$_CAPTURE_PROCESS
DBA_CAPTURE_EXTRA_ATTRIBUTES DBMS_STREAMS_RPC STREAMS$_PROCESS_PARAMS
DBA_PROPAGATION DBMS_SYSTEM _GV$SXGG_APPLY_COORDINATOR
DBMS_APPLY_ADM GV$DATABASE _GV$SXGG_APPLY_READER
DBMS_CAPTURE_ADM GV$TRANSACTION _GV$SXGG_APPLY_SERVER
DBMS_CAPTURE_SWITCH_ADM STREAMS$_APPLY_MILESTONE _GV$SXGG_CAPTURE
DBMS_LOCK STREAMS$_APPLY_PROCESS  
Documented No
First Available Not Known
Security Model Owned by SYS with no privileges granted.
Source {ORACLE_HOME}/rdbms/admin/prvthscp.plb
Subprograms
 
CAN_SWITCH
Changes a capture process' mode dbms_capture_switch_internal.can_switch(
canon_capture_name IN VARCHAR2,
switch_to_mode     IN VARCHAR2);
TBD
 
CAPTURE_WAIT_FOR_SCN
Sets the wait interval and maximum wait time for capturing a specified transaction identified by its SCN dbms_capture_switch_internal.capture_wait_for_scn(
canon_capture_name IN VARCHAR2,
SCN                IN NUMBER,
WAIT_INTERVAL      IN NUMBER,
maxwait            IN NUMBER);
TBD
 
DISPLAY_MESSAGE
Posts a message in the capture stream dbms_capture_switch_internal.display_message(
msg   IN VARCHAR2,
alert IN BOOLEAN);
exec dbms_capture_switch_internal.display_message('Hello World', TRUE);
 
GET_APPLY_NAME_AND_DBLINK
Undocumented dbms_capture_switch_internal.get_apply_name_and_dblink(
canon_capture_name IN  VARCHAR2,
canon_apply_name   OUT VARCHAR2,
database_link      OUT VARCHAR2);
TBD
 
GET_DATABASE_SCNS
Displays the current SCN, the minimum start SCN for capture, and the associated message dbms_capture_switch_internal.get_database_scns(
current_scn   OUT NUMBER,
min_start_scn OUT NUMBER,
message       OUT VARCHAR2);
SELECT current_scn
FROM v$database;

CURRENT_SCN
-----------
   22401265

DECLARE
 cur_scn NUMBER;
 min_scn NUMBER;
 message VARCHAR2(256);
BEGIN
  dbms_capture_switch_internal.get_database_scns(cur_scn, min_scn, message);
  dbms_output.put_line(TO_CHAR(cur_scn));
  dbms_output.put_line(TO_CHAR(min_scn));
  dbms_output.put_line(message);
END;
/
22401306
22401306
Switch to use apply-state ckpt: No active transactions, use the current SCN (22400753) for the new oldest SCN.
 
GET_OLDEST_SCN
Returns the oldest SCN associated with the named apply process dbms_capture_switch_internal.get_oldest_scn(
canon_apply_name IN  VARCHAR2,
oldest_scn       OUT NUMBER);
TBD
 
RESTART_PROCESS
Restarts the named process dbms_capture_switch_internal.restart_process(
canon_process_name   IN VARCHAR2,
process_type         IN VARCHAR2,
max_restart_attempts IN NUMBER,
wait_interval        IN NUMBER);
TBD
 
SET_OLDEST_SCN
Undocumented dbms_capture_switch_internal.set_oldest_scn(
CANON_APPLY_NAME IN VARCHAR2,
SCN              IN NUMBER,
IS_RANGE         IN BOOLEAN);
TBD
 
WAITFOR_CAPTURE
Undocumented dbms_capture_switch_internal.waitFor_capture(
canon_capture_name IN VARCHAR2,
activity           IN VARCHAR2,
wait_internal      IN NUMBER,
max_wait           IN NUMBER);
TBD
 
WAIT_CAPTURE_MAKE_PROGRESS
Undocumented dbms_capture_switch_internal.wait_capture_make_progress(
canon_capture_name IN VARCHAR2,
WAIT_INTERVAL      IN NUMBER,
maxwait            IN NUMBER);
TBD

Related Topics
Built-in Functions
Built-in Packages
DBMS_APPLY_ADM
DBMS_CAPTURE_ADM
DBMS_CAPTURE_SWITCH_ADM
DBMS_LOCK
DBMS_LOGREP_UTIL
DBMS_SYSTEM
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