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.
dbms_scn.getCurrentSCNParams(
rsl OUT NUMBER,
headroom_in_scn OUT NUMBER,
headroom_in_sec OUT NUMBER,
cur_scn_compat OUT NUMBER,
max_scn_compat OUT NUMBER);
PRAGMA SUPPLEMENTAL_LOG_DATA (GetCurrentSCNParams, READ_ONLY);
dbms_scn.GetSCNAutoRolloverParams(
effective_auto_rollover_ts OUT DATE,
target_compat OUT NUMBER,
is_enabled OUT BOOLEAN);
PRAGMA SUPPLEMENTAL_LOG_DATA (GetSCNAutoRolloverParams, READ_ONLY);
DECLARE
b BOOLEAN;
eart DATE;
tcompat NUMBER;
BEGIN
dbms_scn.GetSCNAutoRolloverParams(eart, tcompat, b);
dbms_output.put_line(TO_CHAR(eart));
dbms_output.put_line(TO_CHAR(tcompat));
IF b THEN
dbms_output.put_line('Enabled');
ELSE
dbms_output.put_line('Not Enabled');
END IF;
END;
/
Returns False if the 'compat'; parameter value is invalid, and the OUT parameters
are not updated
dbms_scn.getSCNParamsByCompat(
compat IN NUMBER,
rsl OUT NUMBER,
headroom_in_scn OUT NUMBER,
headroom_in_sec OUT NUMBER)
RETURN BOOLEAN;
PRAGMA SUPPLEMENTAL_LOG_DATA (GetSCNParamsByCompat, READ_ONLY);
DECLARE
b BOOLEAN;
rsl NUMBER;
hscn NUMBER;
hsec NUMBER;
BEGIN
b := dbms_scn.getSCNParamsByCompat(1, rsl, hscn, hsec);
IF b THEN
dbms_output.put_line('T');
ELSE
dbms_output.put_line('F');
END IF;
dbms_output.put_line(TO_CHAR(rsl));
dbms_output.put_line(TO_CHAR(hscn));
dbms_output.put_line(TO_CHAR(hsec));
END;
/