Oracle | DBMS_SWAT

Oracle DBMS_SWAT_INTERNAL Version 21c

General Information

Library Note

Morgan's Library Page Header

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 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