Oracle | DBMS_INMEMORY

Oracle DBMS_INMEMORY 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 Utility package supporting In-Memory Columnar Caching

AUTHID CURRENT_USER

Dependencies

ALL_TAB_COLS	DBMS_AUTOIM_INTERNAL	DBMS_STANDARD
ALL_TAB_PARTITIONS	DBMS_INMEMORY_ADMIN	PLITBLM
ALL_TAB_SUBPARTITIONS	DBMS_INMEMORY_LIB	PRVT_DBMS_INMEMORY_ADMIN
ALL_XTERNAL_TAB_PARTITIONS	DBMS_SQL	PRVT_ILM
DBMS_ASSERT

Documented Yes: Packages and Types Reference

First Available 12.1

Security Model Owned by SYS with EXECUTE granted to PUBLIC

Source {ORACLE_HOME}/rdbms/admin/dbmsinmem.sql

Subprograms

IME_DROP_EXPRESSIONS	POPULATE_GRAPH	REPOPULATE_GRAPH
POPULATE	REPOPULATE	SEGMENT_DEALLOCATE_VERSIONS

IME_DROP_EXPRESSIONS

Drops a specified set of SYS_IME virtual columns from a table dbms_inmemory_admin.deallocate_version( schema_name IN VARCHAR2, table_name IN VARCHAR2, column_name IN VARCHAR2 DEFAULT NULL);

exec dbms_inmemory_admin.deallocate_version('UWCLASS', 'SERVERS', 'LATITUDE');

      

      PL/SQL procedure successfully completed.

POPULATE

Populate the in-memory representation of the specified table/partition if an in-memory representation exists dbms_inmemory.populate( schema_name IN VARCHAR2, table_name IN VARCHAR2, partition_name IN VARCHAR2 DEFAULT NULL);

exec dbms_inmemory.populate('UWCLASS', 'SERVERS');

      

      PL/SQL procedure successfully completed.

POPULATE_GRAPH (new 23ai)

Populate the in-memory representation of the specified property graph if one exists. dbms_inmemory.populate_graph( schema_name IN VARCHAR2, graph IN VARCHAR2);

exec dbms_inmemory.populate_graph('UWCLASS', 'UWPROPGRAPH');

      

      PL/SQL procedure successfully completed.

REPOPULATE

Repopulate the in-memory representation of the specified table/partition if an in-memory representation exists dbms_inmemory.repopulate( schema_name IN VARCHAR2, table_name IN VARCHAR2, partition_name IN VARCHAR2 DEFAULT NULL, force IN BOOLEAN DEFAULT FALSE);

exec dbms_inmemory.repopulate('UWCLASS', 'SERVERS');

      

      PL/SQL procedure successfully completed.

REPOPULATE_GRAPH (new 23ai)

Repopulate the in-memory representation of the specified property graph if one exists. dbms_inmemory.repopulate_graph( schema_name IN VARCHAR2, graph_name IN VARCHAR2, force IN BOOLEAN DEFAULT FALSE);

exec dbms_inmemory.repopulate_graph('UWCLASS', 'UWPROPGRAPH');

      

      PL/SQL procedure successfully completed.

SEGMENT_DEALLOCATE_VERSIONS

Deallocates non-current IMCUs in the in-memory column store dbms_inmemory.segment_deallocate_versions( schema_name IN VARCHAR2, table_name IN VARCHAR2, partition_name IN VARCHAR2 DEFAULT NULL, spcpressure IN BOOLEAN DEFAULT FALSE;

exec dbms_inmemory.segment_deallocate_versions('UWCLASS', 'SERVERS', spcpressure=>TRUE);

      

      PL/SQL procedure successfully completed.