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 will be available on generic Linux platforms in January and soon on AIX and Windows

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