Oracle DBMS_MEMOPTIMIZE
Version 18.1.0.0

General Information
Library Note Morgan's Library Page Header
Are you prepared for the release of Oracle Database 18c ... the first autonomous database? We are here at the Library. It is time for DBAs to stop fighting robots with their fingers and losing ... time to start using our intelligence and winning.
Purpose Provides an interface for managing data in the memoptimize pool which is an SGA cache that stores table data and hash index related to the Memoptimized Rowstore.

The package provides the following functionality
• Populate the Memoptimized Rowstore hash index with the data related to a specific table.
• Remove the data from the Memoptimized Rowstore hash index related to a specific table.
AUTHID CURRENT_USER
Dependencies
ALL_TAB_PARTITIONS ALL_TAB_SUB_PARTITIONS DBMS_MEMOPTIMIZE_LIB
Documented Yes
Exceptions
Error Code Reason
ORA-62135 Invalid schema name
ORA-62136 Invalid table name
First Available 18.1.0.0
Initialization (Startup) Parameters MEMOPTIMIZE_POOL_SIZE
Security Model Owned by SYS with EXECUTE granted to PUBLIC
Source {ORACLE_HOME}/rdbms/admin/dbmsmemoptimize.sql
Subprograms
 
DROP_OBJECT (new 18.1)
Removes the in-memory hash index for a table dbms_memoptimize.drop_object(
schema_name    IN VARCHAR2,
table_name     IN VARCHAR2,
partition_name IN VARCHAR2 DEFAULT NULL);
exec dbms_memooptimize.drop_object('UWCLASS', 'SERVERS');
 
POPULATE (new 18.1)
Populates the in-memory hash index for a table dbms_memoptimize.populate(
schema_name    IN VARCHAR2,
table_name     IN VARCHAR2,
partition_name IN VARCHAR2 DEFAULT NULL);
exec dbms_memooptimize.populate('UWCLASS', 'SERVERS');

Related Topics
Built-in Functions
Built-in Packages
DBMS_INMEMORY
DBMS_INMEMORY_ADMIN
In Memory Database
Startup Parameters
What's New In 12cR2
What's New In 18cR1

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