DBMS_INMEMORY_ADMIN Package

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

• Summary of DBMS_INMEMORY_ADMIN Subprograms
  This table summarizes the subprograms included in the DBMS_INMEMORY_ADMIN package.

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.

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

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;
/