Oracle Cloud Infrastructure Documentation

DBMS_INMEMORY_ADMIN Package

The DBMS_INMEMORY_ADMIN package enables you to manage the In-Memory area and In-Memory FastStart.

Parent topic: Autonomous Database Supplied Package Reference

Summary of DBMS_INMEMORY_ADMIN Subprograms

This table summarizes the subprograms included in the DBMS_INMEMORY_ADMIN package.

Subprogram Description

AIM_GET_PARAMETER Procedure

This procedure obtains the current values for parameters that control Automatic In-Memory.

AIM_SET_PARAMETER Procedure

The procedure customizes the execution environment of Automatic In-Memory.

FASTSTART_DISABLE Procedure

This procedure disables the In-Memory FastStart (IM FastStart) feature.

FASTSTART_ENABLE Procedure

This procedure enables IM FastStart and assigns a tablespace.

FASTSTART_MIGRATE_STORAGE Procedure

This procedure moves all IM FastStart data and metadata from the existing tablespace to the specified new tablespace.

GET_FASTSTART_TABLESPACE Function

This function returns the name of the tablespace that is currently designated for IM FastStart.

IME_CAPTURE_EXPRESSIONS Procedure

This procedure captures the 20 most frequently accessed (“hottest”) expressions in the database in the specified time interval.

IME_CLOSE_CAPTURE_WINDOW Procedure

This procedure signals the end of the current expression capture window.

IME_DROP_ALL_EXPRESSIONS Procedure

This procedure drops all SYS_IME expression virtual columns in the database.

IME_GET_CAPTURE_STATE Procedure

This procedure returns the current capture state of the expression capture window and the timestamp of the most recent modification.

IME_OPEN_CAPTURE_WINDOW Procedure

This procedure signals the beginning of an expression capture window.

IME_POPULATE_EXPRESSIONS Procedure

This procedure forces the population of expressions captured in the latest invocation of DBMS_INMEMORY_ADMIN.IME_CAPTURE_EXPRESSIONS.

POPULATE_WAIT Function

Initiates population of all INMEMORY objects that have a priority greater than or equal to the specified priority, and sets a timeout interval within which population must occur.

SET_SGA_PERCENTAGE Procedure

This procedure modifies the maximum In-Memory size for your database.

Parent topic: DBMS_INMEMORY_ADMIN Package

SET_SGA_PERCENTAGE Procedure

Use DBMS_INMEMORY_ADMIN.SET_SGA_PERCENTAGE to modify the maximum In-Memory size for your database.

Syntax


DBMS_INMEMORY_ADMIN.SET_SGA_PERCENTAGE (
     sga_percentage IN NUMBER);
Parameter Description
sga_percentage

This specifies a value for the maximum In-Memory size for your Autonomous Database. The supplied sga_percentage value must be in the range of 0 and 70.

This parameter is mandatory.

Usage Note

To run DBMS_INMEMORY_ADMIN.SET_SGA_PERCENTAGE you must be logged in as the ADMIN user or have the EXECUTE privilege on DBMS_INMEMORY_ADMIN.

Example

BEGIN
     DBMS_INMEMORY_ADMIN.SET_SGA_PERCENTAGE(60);
END;
/