Oracle DBMS_SWAT_ARM

Oracle DBMS_SWAT_ARM_INTERNAL Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

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.