DBMS_MEMOPTIMIZE_ADMIN package provides the interface for flushing the Memoptimized Rowstore data buffered in the large pool to disk.
This chapter contains the following topics:
103.1 DBMS_MEMOPTIMIZE_ADMIN Overview
DBMS_MEMOPTIMIZE_ADMIN package provides the interface for flushing the Memoptimized Rowstore data that is buffered in the large pool to disk.
The Memoptimized Rowstore provides the following functionality:
Fast ingest optimizes the processing of high-frequency, single-row data inserts. Fast ingest uses the large pool in the SGA for buffering the inserts before writing them to disk.
Fast lookup enables fast retrieval of data for high-frequency queries. Fast lookup uses a separate memory area in the SGA called the memoptimize pool for buffering the data queried from tables.
DBMS_MEMOPTIMIZE_ADMIN package provides the following operation related to fast ingest of the Memoptimized Rowstore:
Flush fast ingest data from the large pool to disk for all sessions.
103.2 Summary of DBMS_MEMOPTIMIZE_ADMIN Subprograms
This table lists the
DBMS_MEMOPTIMIZE_ADMIN subprograms and briefly describes them.
Table 103-1 DBMS_MEMOPTIMIZE_ADMIN Package Subprograms
Flushes all the fast ingest data of the Memoptimize Rowstore from the large pool to disk for all the sessions.