1. Database Reference
  2. Initialization Parameters
  3. Initialization Parameters
  4. OLAP_PAGE_POOL_SIZE

1.228 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

OLAP_PAGE_POOL_SIZE = integer [K | M | G]

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

WARNING:

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 Database