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.
| 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.
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 AI Database. The supplied 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;
/