Oracle 18cR3 DBMS_CAPTURE_SWITCH

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	GET_DATABASE_SCNS	SET_OLDEST_SCN
CAPTURE_WAIT_FOR_SCN	GET_OLDEST_SCN	WAITFOR_CAPTURE
DISPLAY_MESSAGE	RESTART_PROCESS	WAIT_CAPTURE_MAKE_PROGRESS
GET_APPLY_NAME_AND_DBLINK

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