Oracle | DBMS_AUTOIM

Oracle DBMS_AUTOIM_INTERNAL Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

Purpose Internal support for the DBMS_AUTOIM, Automatic In-Memory, package which allows a DBA to configure the AIM task and generate report from AIM task activities.

AUTHID DEFINER

Dependencies SELECT name FROM dba_dependencies WHERE referenced_name = 'DBMS_AUTOIM_INTERNAL' UNION SELECT referenced_name FROM dba_dependencies WHERE name = 'DBMS_AUTOIM_INTERNAL' ORDER BY 1;

Returns 50 objects

Documented Yes: Database In-Memory Guide

First Available 23ai

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
CLEAR_ALL	GET_PARAMETER

ACTIVITY_REPORT (new 23ai)

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 23ai)

Undocumented dbms_autoim_internal.aim_init;

exec dbms_autoim_internal.aim_init;

      

      PL/SQL procedure successfully completed.

CLEAR_ALL (new 23ai)

Undocumented dbms_autoim_internal.clear_all;

exec dbms_autoim_internal.clear_all;

      *

      ORA-01422 exact fetch returned more than the requested number of rows (1)

EXEC_ADVISOR (new 23ai)

Undocumented dbms_autoim_internal.exec_advisor;

exec dbms_autoim_internal.exec_advisor;

      

      PL/SQL procedure successfully completed.

EXEC_AUTO_TASK (new 23ai)

Undocumented dbms_autoim_internal.exec_auto_task(task_id IN NUMBER);

exec dbms_autoim_internal.exec_auto_task(1);

      

      PL/SQL procedure successfully completed.

GET_PARAMETER (new 23ai)

Returns the value of the input parameter dbms_autoim_internal.get_parameter( parameter_name IN VARCHAR2, parameter_value OUT VARCHAR2);

TBD

LOG_TRACE (new 23ai)

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 23ai)

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

TBD