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 is now availble. If you haven't you downloaded already: Why?

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.