| General Information |
| Library Note |
Morgan's Library Page Header
|
| Purpose |
Internal utilities that manage automatically created, think autonomous self-tuning, materialized views. |
| AUTHID |
DEFINER |
| Dependencies |
| ALL_USERS |
DBMS_SWAT_MM_UTILS |
| DBMS_AUTO_CLUSTERING_INTERNAL |
DBMS_SWAT_VER_INTERNAL |
| DBMS_STANDARD |
DBMS_SYSTEM |
| DBMS_STATS_INTERNAL |
DBMS_SYS_ERROR |
| DBMS_SWAT |
DUAL |
| DBMS_SWAT_LIB |
SWAT$CONFIG_PARAMS |
| DBMS_SWAT_MM_INTERNAL |
SWAT_ARM_FEEDBACKS |
|
| 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
{ORACLE_HOME}/rdbms/admin/prvtswat.plb |
| Subprograms |
|
| |
CLEAR_SWAT_STR_PARAMETER (new
23ai)  |
| Undocumented |
dbms_swat_internal.clear_swat_str_parameter(parname IN VARCHAR2); |
| TBD |
| |
| IS_STORAGE_CLAUSE_VALID (new
23ai) |
| Undocumented |
dbms_swat_internal.is_storage_clause_valid(storageclause IN VARCHAR2) RETURN BOOLEAN; |
BEGIN
IF dbms_swat_internal.is_storage_clause_valid('ZZYZX') THEN
dbms_output.put_line('T');
ELSE
dbms_output.put_line('F');
END IF;
END;
/
F
PL/SQL procedure successfully completed. |
| |
| SET_SWAT_NUM_PARAMETER (new
23ai) |
| Undocumented |
dbms_swat_internal.set_swat_num_parameter(
parname IN VARCHAR2,
parvalue IN NUMBER,
updatedby IN VARCHAR2); |
| TBD |
| |
| SET_SWAT_STR_PARAMETER (new
23ai) |
| Undocumented |
dbms_swat_internal.set_swat_str_parameter(
parname IN VARCHAR2,
parvalue IN VARCHAR2,
updatedby IN VARCHAR2); |
| TBD |
| |
| UPDATE_INCLUDE_EXCLUDE_PARAMETER (new
23ai) |
| Undocumented |
dbms_swat_internal.update_include_exclude_parameter(
parname IN VARCHAR2,
parvalue IN NUMBER,
updatedby IN VARCHAR2); |
| TBD |
| |
| VALIDATE SCHEMA (new
23ai) |
| Undocumented |
dbms_swat_internal.validate_parameter(uname IN VARCHAR2); |
exec dbms_swat_internal.validate_parameter('C##APPLIC');
PL/SQL procedure successfully completed. |
| |
| GET_SWAT_NUM_PARAMETER |
| 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');
DBMS_SWAT_INTERNAL.GET_SWAT_NUM_PARAMETER('AUTO_MV_RETENTION')
--------------------------------------------------------------
373 |
| |
| GET_SWAT_STR_PARAMETER |
| 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');
DBMS_SWAT_INTERNAL.GET_SWAT_STR_PARAMETER('AUTO_ZMAP_MODE')
-----------------------------------------------------------
OFF |