Oracle | DBMS

Oracle DBMS_AUTOIM 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 Automatic In-Memory (AIM) and Automatic Data Optimization (ADO) utilities that allow a DBA to configure the AIM task and generate activity reports

AUTHID CURRENT_USER

Dependencies

DBMS_AUTOIM_INTERNAL	DBMS_SYS_ERROR	PRVT_REPORT_TAGS
DBMS_REPORT	PRVT_ADVISOR	XMLTYPE

Documented No

First Available 23ai

Initialization Parameters INMEMORY_AUTOMATIC_LEVEL OFF - the installation default value LOW MEDIUM HIGH

ALTER SYSTEM SET inmemory_automatic_level='HIGH'

      COMMENT='set 12/20/2023'

      SID='*'

      SCOPE=BOTH;

      

      -- the container clause is not valid for this 
      parameter

Pragmas PRAGMA SUPPLEMENTAL_LOG_DATA(default, UNSUPPORTED);

Security Model Owned by SYS with EXECUTE granted to the DBA role.

Source {ORACLE_HOME}/rdbms/admin/dbmsaim.sql
{ORACLE_HOME}/rdbms/admin/prvtaim.plb

Subprograms

ACTIVITY_REPORT

GET_PARAMETER

SET_PARAMETER

ACTIVITY_REPORT (new 23ai)

Reports AIM task activity for given feature(s) within specified time interval dbms_autoim.activity_report( feature_id IN NUMBER := NULL, start_time IN TIMESTAMP WITH TIME ZONE := NULL, end_time IN TIMESTAMP WITH TIME ZONE := NULL, type IN VARCHAR2 := 'TEXT', -- html, text, xml level IN VARCHAR2 := 'BASIC') -- basic, detailed RETURN CLOB;

SELECT dbms_autoim.activity_report(type => 'HTML', level => 'DETAILED');

GET_PARAMETER (new 23ai)

Returns a configuration parameter for AIM features dbms_autoim.get_parameter( parameter_name IN VARCHAR2, parameter_value OUT VARCHAR2);

DECLARE

       outVal dbms_id;

      BEGIN

        dbms_autoim.get_parameter('AIM_TASK', outVal;

        dbms_output.put_line(outVal);

      END;

      /

      *

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

SET_PARAMETER (new 23ai)

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

exec dbms_autoim.set_parameter('AIM_TASK', 'ENABLE');

      

      PL/SQL procedure successfully completed.