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.
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);