Oracle DBMS_CAPTURE_SWITCH_INTERNAL
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 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);
 
 
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 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