99 DBMS_MEMOPTIMIZE

The DBMS_MEMOPTIMIZE package provides an interface for managing data in the memoptimize pool.

This chapter contains the following topics:

• DBMS_MEMOPTIMIZE Overview

• Summary of DBMS_MEMOPTIMIZE Subprograms

99.1 DBMS_MEMOPTIMIZE Overview

The DBMS_MEMOPTIMIZE package provides an interface for managing data in the memoptimize pool. The memoptimize pool is a memory area in the system global area (SGA) that stores table data and hash index related to Memoptimized Rowstore.

The DBMS_MEMOPTIMIZE 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.

99.2 Summary of DBMS_MEMOPTIMIZE Subprograms

This table lists the DBMS_MEMOPTIMIZE subprograms and briefly describes them.

Table 99-1 DBMS_MEMOPTIMIZE Package Subprograms

Procedure	Description
DROP_OBJECT Procedure	Removes the in-memory hash index related to a table.
POPULATE Procedure	Populates the in-memory hash index with a table data.

99.2.1 DROP_OBJECT Procedure

This procedure removes the in-memory hash index for a table.

Syntax

DBMS_MEMOPTIMIZE.DROP_OBJECT (
   schema_name        IN VARCHAR2,
   table_name         IN VARCHAR2,
   partition_name     IN VARCHAR2 DEFAULT NULL);

Parameters

Table 99-2 DROP_OBJECT Procedure Parameters

Parameter	Description
schema_name	Name of the schema.
table_name	Name of the table whose data is to be removed from the in-memory hash index.
partition_name	Name of the table partition whose data is to be removed from the in-memory hash index. This is an optional parameter and its default value is NULL.

99.2.2 POPULATE Procedure

This procedure populates the in-memory hash index for a table.

Syntax

DBMS_MEMOPTIMIZE.POPULATE (
   schema_name        IN VARCHAR2,
   table_name         IN VARCHAR2,
   partition_name     IN VARCHAR2 DEFAULT NULL);

Parameters

Table 99-3 POPULATE Procedure Parameters

Parameter	Description
schema_name	Name of the schema.
table_name	Name of the table from which the data is to be stored into the in-memory hash index.
partition_name	Name of the table partition from which the data is to be stored into the in-memory hash index. This is an optional parameter and its default value is NULL.