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 is now availble. If you haven't you downloaded already: Why?

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.