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

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.