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 (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.

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_SWAT
DBMS_SWAT_INTERNAL
DBMS_SWAT_MM_INTERNAL
DBMS_SWAT_MM_UTILS
DBMS_SWAT_VER_INTERNAL
Materialized Views
What's New In 19c
What's New In 20c-21c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx