Oracle | DBMS_SWAT_ARM

Oracle DBMS_SWAT_ARM_INTERNAL Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose Undocumented support for Autonomous Database Automatic Materialized View Management

AUTHID DEFINER

Dependencies

DBA_AUTO_MV_ANALYSIS_EXECUTIONS	DBMS_SWAT	WRI$_ADV_AUTOMV_MV_CAND
DBA_AUTO_MV_ANALYSIS_TASK	DBMS_SYS_ERROR	WRI$_ADV_AUTOMV_MV_QRY_MAP
DBA_SQLSET	DBMS_UTILITY	WRI$_ADV_AUTOMV_RSET
DBA_SQLSET_REFERENCES	PRVT_ACCESS_ADVISOR	WRI$_ADV_AUTOMV_STATE
DBMS_ADVISOR	PRVT_ADVISOR	WRI$_ADV_EXECUTIONS
DBMS_APPLICATION_INFO	SQLSET_ROW	WRI$_ADV_JOURNAL
DBMS_AUTOTASK_PRVT	SWAT$CONFIG_PARAMS	WRI$_ADV_MESSAGE_GROUPS
DBMS_AUTO_TASK_ADMIN	SWAT_ARM_STATUS$	WRI$_ADV_RECOMMENDATIONS
DBMS_OUTPUT	UTL_CALL_STACK	WRI$_ADV_REC_ACTIONS
DBMS_SQLTUNE	WRI$_ADV_ACTIONS	WRI$_ADV_SQLACCESS_ADV
DBMS_STANDARD	WRI$_ADV_AUTOMV_DT	WRI$_ADV_TASKS

Documented No

First Available 21c

Security Model Owned by SYS with no privileges granted.

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

Subprograms

IS_AUTO_MV_TASK	SARM_CAP_CUR_CAC	SARM_PROC_TASK
RESET_AUTO_MV_ADV_PARAMS	SARM_CLEANUP	SARM_PURGE_HISTORY
RESET_EXECUTION	SARM_INIT

IS_AUTO_MV_TASK (new 21c)

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.

RESET_AUTO_MV_ADV_PARAMS (new 21c)

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_EXECUTION (new 21c)

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 (new 21c)

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 (new 21c)

Undocumented dbms_swat_arm_internal.sarm_cleanup;

exec dbms_swat_arm_internal.sarm_cleanup;

      

      PL/SQL procedure successfully completed.

SARM_INIT (new 21c)

Undocumented dbms_swat_arm_internal.sarm_init;

exec dbms_swat_arm_internal.sarm_init;

      

      PL/SQL procedure successfully completed.

SARM_PROC_TASK (new 21c)

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

SELECT ownerid, stsname

      FROM exu112dlob;

      

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

      

      PL/SQL procedure successfully completed.

SARM_PURGE_HISTORY (new 21c)

Undocumented dbms_swat_arm_internal.sarm_purge_history(days IN NUMBER);

exec dbms_swat_arm_internal.sarm_purge_history(7);

      *

      ERROR at line 1:

      ORA-00933: SQL command not properly ended

      ORA-06512: at "SYS.DBMS_SWAT_ARM_INTERNAL", line 1533

      ORA-06512: at "SYS.DBMS_SWAT_ARM_INTERNAL", line 1528

      ORA-06512: at line 1

      

      -- this object appears to have had inadequate 
      testing as it has an internal bug.