Oracle | DBMS_AUTOIM

Oracle DBMS_AUTOIM_INTERNAL Version 23c

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 Internal support for the DBMS_AUTOIM package which allows a DBA to configure the AIM task and generate report from AIM task activities.

AUTHID DEFINER

Dependencies

AUTO_IM_MONITOR_INFO_ROW	DBMS_AUTO_TASK_ADMIN	PRVT_ADVISOR
AUTO_IM_MONITOR_INFO_TAB	DBMS_ILM	TABCOMPART$
AUTO_IM_RANK_COL_ROW	DBMS_SQLPA	TABPART$
AUTO_IM_RANK_COL_TAB	DBMS_STANDARD	TABSUBPART$
COL$	DBMS_SYSTEM	USER$
DBA_ADVISOR_EXECUTIONS	DBMS_SYS_ERROR	WRI$_ADV_AUTOIM
DBA_ADVISOR_FINDINGS	DUAL	WRI$_ADV_EXECUTIONS
DBA_ADVISOR_SQLSTATS	GV$AUTO_IM_REPOP_STATUS	WRI$_ADV_TASKS
DBA_JOINGROUPS	GV$IM_COL_CU	XMLTYPE
DBA_OBJECTS	GV$IM_SEGMENTS	auto_im_column_tracking$
DBS_TAB_COLS_V$	GV$INMEMORY_AREA	auto_im_feature_monitoring$
DBMS_ADVISOR	IM_DOMAIN$	auto_im_feature_workload$
DBMS_ASSERT	IM_JOINGROUP$	auto_im_join_group_tacking$
DBMS_AUTOIM	OBJ$	auto_im_task_state
DBMS_AUTOIM_LIB	PLITBLM	auto_im_workload$

Documented Yes: Database In-Memory Guide

First Available 23.1

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/prvsaim.plb
{ORACLE_HOME}/rdbms/admin/prvtaim.plb

Subprograms

ACTIVITY_REPORT	EXEC_ADVISOR	LOG_TRACE
AIM_INIT	EXEC_AUTO_TASK	SET_PARAMETER

ACTIVITY_REPORT (new 23c)

Reports AIM task activity for given feature(s) within specified time interval dbms_autoim_internal.activity_report( report_xml IN OUT sys.xmlType, feature_id IN NUMBER, start_time IN TIMESTAMP WITH TIME ZONE, end_time IN TIMESTAMP WITH TIME ZONE, type IN VARCHAR2, level IN VARCHAR2);

TBD

AIM_INIT (new 23c)

Undocumented dbms_autoim_internal.aim_init;

exec dbms_autoim_internal.aim_init;

      

      PL/SQL procedure successfully completed.

EXEC_ADVISOR (new 23c)

Undocumented dbms_autoim_internal.exec_advisor;

exec dbms_autoim_internal.exec_advisor;

      

      PL/SQL procedure successfully completed.

EXEC_AUTO_TASK (new 23c)

Undocumented dbms_autoim_internal.exec_auto_task(task_id IN NUMBER);

exec dbms_autoim_internal.exec_auto_task(1);

      

      PL/SQL procedure successfully completed.

LOG_TRACE (new 23c)

Undocumented dbms_autoim_internal.log_trace(log_str IN VARCHAR2);

exec dbms_autoim_internal.log_trace('test_string');

      

      PL/SQL procedure successfully completed.

      

      -- a search for the string in the diag directory was unsuccessful.

SET_PARAMETER (new 23c)

Sets configuration parameter for AIM features dbms_autoim_internal.set_parameter( parameter_name IN VARCHAR2, parameter_value IN VARCHAR2);

TBD