Oracle | DBMS_SWAT_ARM

Oracle DBMS_SWAT_ARM_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 Undocumented support for Autonomous Database Automatic Materialized View Management

AUTHID DEFINER

Dependencies

ALL_SQLSET	DBMS_SWAT_VER_INTERNAL
DBA_ADVISOR_EXECUTIONS	DBMS_SYS_ERROR
DBMS_ADVISOR_TASKS	DBMS_UTILITY
DBA_AUTO_MV_ANALYSIS_EXECUTIONS	PRVT_ACCESS_ADVISOR
DBA_AUTO_MV_ANALYSIS_RECOMMENDATIONS	PRVT_ADVISOR
DBA_AUTO_MV_ANALYSIS_TASK	SQLSET_ROW
DBA_SQLSET	SWAT$CONFIG_PARAMS
DBA_SQLSET_REFERENCES	SWAT_ARM_STATUS$
DBA_SQLSET_STATEMENTS	UTL_CALL_STACK
DBA_TABLES	WRI$_ADV_ACTIONS
DBMS_ADVISOR	WRI$_ADV_AUTOMV_DT
DBMS_APPLICATION_INFO	WRI$_ADV_AUTOMV_MV_CAND
DBMS_AUTOTASK_PRVT	WRI$_ADV_AUTOMV_MV_QRY_MAP
DBMS_AUTO_CLUSTERING_INTERNAL	WRI$_ADV_AUTOMV_RSET
DBMS_AUTO_TASK_ADMIN	WRI$_ADV_AUTOMV_STATE
DBMS_LOCK	WRI$_ADV_EXECUTIONS
DBMS_OUTPUT	WRI$_ADV_JOURNAL
DBMS_SQLTUNE	WRI$_ADV_MESSAGE_GROUPS
DBMS_STANDARD	WRI$_ADV_RECOMMENDATIONS
DBMS_SUMA_LIB	WRI$_ADV_REC_ACTIONS
DBMS_SWAT	WRI$_ADV_SQLACCESS_ADV
DBMS_SWAT_MM_UTILS	WRI$_ADV_TASKS

Documented No

Exceptions

Error Code	Reason
`ORA-03049`	SQL keyword 'DAYS' is not syntactically valid following '...<= SYSDATE - tminter '
`ORA-40216`	`feature not supported`

First Available 21c

Security Model Owned by SYS with no privileges granted.

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

Subprograms

GET_TASK_SCRIPT	RESET_AUTO_MV_ADV_PARAMS	SARM_CLEANUP
IS_AUTO_MV_TASK	RESET_AUTO_MV_PARAMS	SARM_INIT
LOCK_SWAT_ARM	RESET_EXECUTION	SARM_PROC_TASK
RELEASE_SWAT_ARM	SARM_CAP_CUR_CAC	SARM_PURGE_HISTORY

GET_TASK_SCRIPT (new 23ai)

Undocumented dbms_swat_arm_internal.get_task_script( task_name IN VARCHAR2, execname IN VARCHAR2) RETURN CLOB;

TBD

IS_AUTO_MV_TASK

Undocumented dbms_swat_arm_internal.is_auto_mv_task(task_id IN NUMBER) RETURN BOOLEAN;

BEGIN

        IF dbms_swat_arm_internal.is_auto_mv_task(42) THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      END;

      /

      F

      

      PL/SQL procedure successfully completed.

LOCK_SWAT_ARM (new 23ai)

Undocumented dbms_swat_arm_internal.lock_swat_arm(lockhandle IN OUT VARCHAR2) RETURN BOOLEAN;

TBD

RELEASE_SWAT_ARM (new 23ai)

Undocumented dbms_swat_arm_internal.release_swat_arm(lockhandle IN VARCHAR2) RETURN BOOLEAN;

TBD

RESET_AUTO_MV_ADV_PARAMS

Undocumented dbms_swat_arm_internal.reset_auto_mv_adv_params;

exec dbms_swat_arm_internal.reset_auto_mv_adv_params;

      

      PL/SQL procedure successfully completed.

RESET_AUTO_MV_PARAMS (new 23ai)

Undocumented dbms_swat_arm_internal.reset_auto_mv_params;

TBD

RESET_EXECUTION

Undocumented dbms_swat_arm_internal.reset_execution( swatarmtaskid IN NUMBER, swatarmexecname IN VARCHAR2);

exec dbms_swat_arm_internal.reset_execution(42, 'ZZYZX');

      

      PL/SQL procedure successfully completed.

      

      -- clearly inputs are not sanitized

SARM_CAP_CUR_CAC

Undocumented but hangs for more many minutes on a test system before completing. Nothing was written to the alert log. dbms_swat_arm_internal.sarm_cap_cur_cac(del_sts IN BOOLEAN);

exec dbms_swat_arm_internal.sarm_cap_cur_cac(TRUE);

      

      PL/SQL procedure successfully completed.

SARM_CLEANUP

Undocumented dbms_swat_arm_internal.sarm_cleanup;

exec dbms_swat_arm_internal.sarm_cleanup;

      

      PL/SQL procedure successfully completed.

SARM_INIT

Undocumented dbms_swat_arm_internal.sarm_init;

exec dbms_swat_arm_internal.sarm_init;

      

      PL/SQL procedure successfully completed.

SARM_PROC_TASK

Undocumented dbms_swat_arm_internal.sarm_proc_task( stsowner IN VARCHAR2, stsname IN VARCHAR2);

SELECT UNIQUE ownerid, stsname

      FROM exu112dlob

      WHERE rownum < 6;

      

       OWNERID  STSNAME

      --------  --------

             0  SYSTEM

             0  SYSAUX

            13  SYSTEM

             9  SYSTEM

             8  SYSTEM

            24  SYSAUX

            88  SYSAUX

            88  SYSTEM 

           110  SYSAUX

           119  SYSTEM

           121  SYSAUX

           127  SYSAUX

           127  SYSTEM

      

      exec dbms_swat_arm_internal.sarm_proc_task('SYS', 'SYSAUX');

           *

      ORA-40216: feature not supported

SARM_PURGE_HISTORY

Undocumented dbms_swat_arm_internal.sarm_purge_history(days IN NUMBER);

exec dbms_swat_arm_internal.sarm_purge_history(1);

           *

      ORA-03049: SQL keyword 'DAYS' is not syntactically valid following '...<= SYSDATE - tminter '

      
      

      -- this object appears to have had inadequate testing and may have an internal bug.