OLAP_PAGE_POOL_SIZE
OLAP_PAGE_POOL_SIZE specifies (in bytes) the size of the OLAP page pool.
| Property | Description |
|---|---|
| Parameter type | Big integer |
| Syntax |
|
| Default value | 0 |
| Modifiable | ALTER SESSION, ALTER SYSTEM ... DEFERRED |
| Modifiable in a PDB | Yes |
| Range of values | 0, 2097152 (2 MB) to 231 - 1 |
| Basic | No |
Caution: Oracle strongly recommends that you leave this parameter set to its default value of 0. This instructs the database to autonomously adjust the OLAP page pool size to serve the requirements of the analytic workspaces. Setting this parameter to a value other than 0 can lead to errors in OLAP processing or wasted memory.
See Also: Oracle OLAP User’s Guide for more information about the OLAP option for Oracle AI Database