ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling
complimentary technical Workshops on Database Security for the first 30
Oracle Database customers located anywhere in North America, EMEA, LATAM, or
APAC that send an email to
asra_us@oracle.com. Request a Workshop for
your organization today.
Purpose
Internal transaction capture process modification related utilities.
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.
dbms_capture_switch_internal.restart_process(
canon_process_name IN VARCHAR2,
process_type IN VARCHAR2,
max_restart_attempts IN NUMBER,
wait_interval IN NUMBER);