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

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_SWAT
DBMS_SWAT_ARM_INTERNAL
DBMS_SWAT_MM_INTERNAL
DBMS_SWAT_MM_UTILS
DBMS_SWAT_VER_INTERNAL
Materialized Views
What's New In 19c
What's New In 20c-21c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx