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