Oracle DBMS_INMEMORY
Version 19.2.0.1

General Information
Library Note Morgan's Library Page Header
For how many years have you been working with physical servers that are starving your database of the memory necessary to deploy important new performance features such as the Result Cache, Memoptimize Pool, In-Memory Aggregation, In-Memory Column Store, and Full Database Caching? Too long? Contact me to learn how to improve all queries ... not just some queries.
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
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)

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 18cR3
What's New In 19cR2

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-2019 Daniel A. Morgan All Rights Reserved