Oracle DBMS_INMEMORY_ADMIN
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
The Library is currently in the process of being upgraded from Oracle Database Version 12.1.0.2 to 12.2.0.1. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.

Also important ... there are rumors on the web about SPARC and Solaris being discontinued. Welcome to the age of fake news. There is absolutely not a byte of truth to these irresponsible rumors.
Purpose Provides interfaces for managing In-Memory Expressions (IM expressions) and the In-Memory FastStart (IM FastStart) area.

Analytic queries often contain complex expressions or calculations that can consume significant CPU and memory during execution. Use DBMS_INMEMORY_ADMIN procedure to identify these frequently used (“hot”) expressions and populate them in the IM column store. In this way, the database avoids repeated computations and improves performance.
AUTHID CURRENT_USER
Dependencies
ALL_IM_EXPRESSIONS DBA_IM_EXPRESSIONS USER_IM_EXPRESSIONS
     
     
Documented Yes
Exceptions
Error Code Reason
   
   
   
First Available 12.2.0.1
Security Model Owned by SYS with ? granted to ???
Source {ORACLE_HOME}/rdbms/admin/
Subprograms
 
DEALLOCATE_VERSIONS (new 12.2)
Disables the In-Memory FastStart (IM FastStart) feature dbms_inmemory_admin.deallocate_version(spcpressure IN BOOLEAN);
exec dbms_inmemory_admin.deallocate_version(TRUE);
 
FASTSTART_CHECKPOINT (new 12.2)
Undocumented dbms_inmemory_admin.faststart_checkpoint(global IN BOOLEAN);
exec dbms_inmemory_admin.faststart_checkpoint(TRUE);
 
FASTSTART_ENABLE (new 12.2)
Enables IM FastStart and assigns a tablespace dbms_inmemory_admin.faststart_enable(
tbs_name  IN VARCHAR2,
nologging IN BOOLEAN);
exec dbms_inmemory_admin.faststart_enable('UWFS', FALSE);

col owner format a5
col segment_name format a20

SELECT dl.owner, dl.segment_name, SUM(ds.bytes)/1024/1024 MB
FROM dba_logs dl, dba_segments ds
WHERE dl.segment_name = ds.segment_name
AND dl.tablespace_name = 'UWFS'
GROUP BY dl.owner, dl.segment_name;
 
FASTSTART_MIGRATE_STORAGE (new 12.2)
Moves all IM FastStart data and metadata from the existing tablespace to the specified new tablespace. dbms_inmemory_admin.faststart_migrate_storage(tbs_name IN VARCHAR2);
exec dbms_inmemory_admin.faststart_migrate_storage('UWFS');
 
GET_FASTSTART_TABLESPACE (new 12.2)
Returns the name of the tablespace that is currently designated for IM FastStart. dbms_inmemory_admin.get_faststart_tablespace RETURN VARCHAR2;
SELECT dbms_inmemory_admin.get_faststart_tablespace
FROM dual;
 
IME_CAPTURE_EXPRESSIONS (new 12.2)
Captures and populates the 20 most frequently accessed (“hottest”) expressions in the database in the specified time range. dbms_inmemory_admin.ime_capture_expressions(snapshot IN VARCHAR2);

Valid values are CUMULATIVE and CURRENT (most recent 24 hours)
exec dbms_inmemory_admin.ime_capture_expressions('CURRENT');

Related Topics
DBMS_INMEMORY
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