Oracle DBMS_SWAT

Oracle DBMS_SWAT_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 utilities that manage automatically created, think autonomous self-tuning, materialized views.

AUTHID DEFINER

Dependencies

DBMS_SWAT_MM_INTERNAL

DBMS_SWAT_MM_UTILS

SWAT$CONFIG_PARAMS

Documented No

Exceptions

Error Code	Reason
ORA-38133	Invalid parameter name
ORA-38134	Invalid parameter value

First Available 21c

Security Model Owned by SYS with EXECUTE granted to the DBA role

Source {ORACLE_HOME}/rdbms/admin/prvsswat.plb

Subprograms

GET_SWAT_NUM_PARAMETER

GET_SWAT_STR_PARAMETER

GET_SWAT_NUM_PARAMETER (new 21c)

Return a SWAT numeric parameter dbms_swat_internal.get_swat_num_parameter(parname IN VARCHAR2) RETURN NUMBER;

SELECT parameter_name, parameter_num_value

      FROM swat$config_params

      WHERE parameter_num_value IS NOT NULL

      AND rownum < 6

      ORDER BY 1;

      

      PARAMETER_NAME                    PARAMETER_NUM_VALUE

      --------------------------------- -------------------

      AUTO_MV_ANALYZE_REPORT_RETENTION                   32

      AUTO_MV_ANALYZE_WORKLOAD_MIN_TIME                 120

      AUTO_MV_ANALYZE_WORKLOAD_WINDOW                    24

      AUTO_MV_MAINT_REPORT_RETENTION                     31

      AUTO_MV_RETENTION                                 373

      

      SELECT dbms_swat_internal.get_swat_num_parameter('AUTO_MV_RETENTION')

      FROM dual;

      

      
      DBMS_SWAT_INTERNAL.GET_SWAT_NUM_PARAMETER('AUTO_MV_RETENTION')

      --------------------------------------------------------------

                                                                 373

GET_SWAT_STR_PARAMETER (new 21c)

Return a SWAT string parameter dbms_swat_internal.get_swat_str_parameter(parname IN VARCHAR2) RETURN VARCHAR2;

col parameter_str_value format a40

      

      SELECT parameter_name, parameter_str_value

      FROM swat$config_params

      WHERE parameter_str_value IS NOT NULL

      AND rownum < 6

      ORDER BY 1;

      

      PARAMETER_NAME                           PARAMETER_STR_VALUE

      ---------------------------------------- --------------------

      AUTO_MV_MAINT_TASK                       DISABLE

      AUTO_MV_MODE                             OFF

      AUTO_MV_SPACE_BUDGET                     15%

      AUTO_ZMAP_MODE                           OFF

      _AUTO_MV_ADV_AUTOTASK_ENABLED            DISABLE

      

      SELECT dbms_swat_internal.get_swat_str_parameter('AUTO_ZMAP_MODE')

      FROM dual;

      

      
      DBMS_SWAT_INTERNAL.GET_SWAT_STR_PARAMETER('AUTO_ZMAP_MODE')

      -----------------------------------------------------------

      OFF