Oracle | DBMS_INMEMORY

Oracle DBMS_INMEMORY Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose Utility package supporting In-Memory Columnar Caching

AUTHID CURRENT_USER

Dependencies

ALL_TAB_COLS	DBMS_ASSERT	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

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	REPOPULATE	SEGMENT_DEALLOCATE_VERSIONS
POPULATE

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');

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');

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');

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)