Oracle | DBMS_MEMOPTIMIZE

Oracle DBMS_MEMOPTIMIZE_ADMIN Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

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;