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 will be available on generic Linux platforms in January and soon on AIX and Windows

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