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.