Oracle DBMS_INMEMORY
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
Purpose Utility package supporting In-Memory Columnar Caching
AUTHID CURRENT_USER
Dependencies
ALL_TAB_COLS DBMS_INMEMORY_ADMIN DBMS_STANDARD
ALL_TAB_PARTITIONS DBMS_INMEMORY_LIB PLITBLM
ALL_TAB_SUBPARTITIONS DBMS_SQL PRVT_ILM
DBMS_ASSERT    
Documented Yes
First Available 12.1.0.2
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/dbmsinmem.sql
Subprograms
 
IME_DROP_EXPRESSIONS (new 12.2)
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');
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 (new 12.2)
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,
spcpressure    IN BOOLEAN);
exec dbms_inmemory.segment_deallocate_versions('UWCLASS', 'SERVERS', spcpressure=>TRUE)

Related Topics
DBMS_CLIENT_RESULT_CACHE
DBMS_INMEMORY_ADMIN
DBMS_MEMOPTIMIZE
DBMS_RESULT_CACHE
DBMS_RESULT_CACHE_API
DBMS_RESULT_CACHE_INTERNAL
In-Memory Database
Packages
What's New In 12cR1
What's New In 12cR2

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2017 Daniel A. Morgan All Rights Reserved