Oracle | DBMS_CAPTURE_SWITCH

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

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