Oracle | DBMS_SWAT_VER

Oracle DBMS_SWAT_VER_INTERNAL Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

Purpose Internal support for utilities that manage automatically created, think autonomous self-tuning, materialized views.

AUTHID DEFINER

Dependencies SELECT name FROM dba_dependencies WHERE referenced_name = 'DBMS_SWAT_VER_INTERNAL' UNION SELECT referenced_name FROM dba_dependencies WHERE name = 'DBMS_SWAT_VER_INTERNAL' ORDER BY 1;

Returns 57 objects

Documented No

First Available 21c

Security Model Owned by SYS with EXECUTE granted to the

Source {ORACLE_HOME}/rdbms/admin/prvsswatver.plb

Subprograms

CLEANUP_ALL_EXECUTIONS	RECORD_FAILURE	VERIFY_SARM_TASK
RECOMMEND_AND_VERIFY	SVER_AUTO_TASK_SWITCH

CLEANUP_ALL_EXECUTIONS

Undocumented dbms_swat_ver_internal.cleanup_all_executions;

exec dbms_swat_ver_internal.cleanup_all_executions;

      

      PL/SQL procedure successfully completed.

RECOMMEND_AND_VERIFY (new 23ai)

Undocumented dbms_swat_ver_internal.recommend_and_verify( sts_owner IN VARCHAR2, sts_name IN VARCHAR2, workload_start_time IN TIMESTAMP, workload_end_time IN TIMESTAMP, automv_mode IN VARCHAR2, task_name OUT VARCHAR2, execution_name OUT VARCHAR2);

TBD

RECORD_FAILURE

Undocumented dbms_swat_ver_internal.record_failure( mvowner IN VARCHAR2, mvname IN VARCHAR2, feedbackid IN NUMBER, mvimpltime IN DATE, mvddltxt IN CLOB, errnum IN NUMBER, errmsg IN VARCHAR2);

TBD

SVER_AUTO_TASK_SWITCH

Undocumented dbms_swat_ver_internal.sver_auto_task_switch(enable IN BOOLEAN);

exec dbms_swat_ver_internal.sver_auto_task_switch(FALSE);

      

      PL/SQL procedure successfully completed.

VERIFY_SARM_TASK

Undocumented dbms_swat_ver_internal.verify_sarm_task( taskid IN NUMBER execname IN VARCHAR2 stsname IN VARCHAR2 stsowner IN VARCHAR2

TBD