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 (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 21c
What's New In 23c

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-2023 Daniel A. Morgan All Rights Reserved
  DBSecWorx