Oracle | DBMS

Oracle DBMS_SCN 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 SCN Compatibility Project Utilities

AUTHID CURRENT_USER

Constants

Name	Data Type	Value
DBMS_SCN_API_MINOR_VERSION	NUMBER	0
DBMS_SCN_API_MAJOR_VERSION	NUMBER	1

Dependencies

DBMS_SCN_LIB

Documented No

First Available 12.1.0.2

Security Model Owned by SYS with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/rdbms/admin/dbmsscnc.sql

Subprograms

DISABLEAUTOROLLOVER	GETCURRENTSCNPARAMS	GETSCNPARAMSBYCOMPAT
ENABLEAUTOROLLOVER	GETSCNAUTOROLLOVERPARAMS

DISABLEAUTOROLLOVER

Disables SCN Auto Rollover dbms_scn.disableAutoRollover; PRAGMA SUPPLEMENTAL_LOG_DATA (DisableAutoRollover, READ_ONLY);

exec dbms_scn.disableAutoRollover;

ENABLEAUTOROLLOVER

Enables SCN Auto Rollover dbms_scn.enableAutoRollover; PRAGMA SUPPLEMENTAL_LOG_DATA (EnableAutoRollover, READ_ONLY);

exec dbms_scn.enableAutoRollover;

GETCURRENTSCNPARAMS

Returns current SCN Parameters 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);

DECLARE

       rsl  NUMBER;

       hscn NUMBER;

       hsec NUMBER;

       csc  NUMBER;

       msc  NUMBER;

      BEGIN

        dbms_scn.getCurrentSCNParams(rsl, hscn, hsec, csc, msc);

        dbms_output.put_line(TO_CHAR(rsl));

        dbms_output.put_line(TO_CHAR(hscn));

        dbms_output.put_line(TO_CHAR(hsec));

        dbms_output.put_line(TO_CHAR(csc));

        dbms_output.put_line(TO_CHAR(msc));

      END;

      /

GETSCNAUTOROLLOVERPARAMS

Returns SCN Auto RollOver Parameters 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;

      /

GETSCNPARAMSBYCOMPAT

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;

      /