Oracle DBMS_MEMOPTIMIZE_ADMIN
Version 26ai

General Information
Library Note Morgan's Library Page Header
The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows
Purpose The package was written as part of a project referred to as "Fast Lookups" and "Fast Data Ingestion"
AUTHID DEFINER
Dependencies
DBMS_MEMOPTIMIZE_ADMIN_LIB    
Documented Yes: Packages and Types Reference
First Available 19c
Security Model Owned by SYS with EXECUTE granted to the DBA role.
Source {ORACLE_HOME}/rdbms/admin/dbmsmemoptimizeadmin.sql
 
WRITES_FLUSH
Flushes rows from the IGA to disk dbms_memoptimize_admin.write_flushes;
exec dbms_memoptimize_admin.writes_flush;

PL/SQL procedure successfully completed.

Related Topics
Built-in Functions
Built-in Packages
DBMS_MEMOPTIMIZE