Oracle DBMS_MEMOPTIMIZE_ADMIN
Version 26ai

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

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?
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