Oracle | DBMS_MEMOPTIMIZE

Oracle DBMS_MEMOPTIMIZE_ADMIN Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

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

WRITE_FLUSHES

Flushes rows from the IGA to disk dbms_memoptimize_admin.write_flushes;

exec dbms_memoptimize_admin.write_flushes;