8.74 V$MEMOPTIMIZE_WRITE_AREA
V$MEMOPTIMIZE_WRITE_AREA
displays information about fast ingest data in the large pool.
Column | Datatype | Description |
---|---|---|
|
|
Total amount of memory allocated for fast ingest data in the large pool (in bytes) |
|
|
Total amount of memory currently used by fast ingest data in the large pool (in bytes) |
|
|
Total amount of memory currently free for storing fast ingest data in the large pool (in bytes) |
|
|
Number of fast ingest insert operations for which data is still in the large pool and is yet to be written to disk |
|
|
Number of clients currently using fast ingest for inserting data into the database |
|
|
The ID of the container to which the data pertains. Possible values include:
|
Note:
This view is available starting with Oracle Database release 19c, version 19.1.