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