|Oracle9i OLAP User's Guide
Release 2 (22.214.171.124)
Part Number A95295-02
Several packages described in this guide require that
utl_file_dir be set. This parameter enables the RDBMS to write to a file.
Table 6-1 identifies the parameters that affect the performance of Oracle OLAP. Alter your server parameter file or
init.ora file to these values, then restart your database instance.
Half of physical memory
This parameter limits the number of processes that are used for a parallel update. The number of parallel processes is also dependent on the number of analytic workspace extension files that are being updated.
2.5 * maximum number of OLAP users
Oracle9i SQL Reference for information about these parameters.
Take the following steps to set system parameters:
.oraparameters file in a text editor.
The parameters file is located in
/pfile, where sid is the system identifier as defined in
For example, you might enter a command like this so that Oracle can write files to the
OLAP_PAGE_POOL_SIZE is an initialization parameter that is specific to Oracle OLAP. This parameter specifies in bytes the maximum size of the paging cache to be allocated to an OLAP session.
The OLAP paging cache is allocated at the start of an OLAP session and released when the user exits the database. An OLAP session can be initiated by the
OLAP_TABLE function, the
DBMS_AW PL/SQL package, or via command line in OLAP Worksheet.
The minimum value of
OLAP_PAGE_POOL_SIZE is 2 MB. The default value is 32 MB.
The OLAP paging cache is allocated from the User Global Area (UGA). When the database is running in dedicated mode, the UGA is part of the Process Global Area (PGA). When the database is running in multi-threaded server mode (MTS), the UGA is part of the Shared Global Area (SGA).
When the database is running in dedicated mode, you can reset the value of
OLAP_PAGE_POOL_SIZE in an ALTER SESSION statement. If you decrease the value, you should first do an UPDATE in the analytic workspace and a COMMIT in the database. If you increase the value to a size greater than the available memory,
OLAP_PAGE_POOL_SIZE remains the same.
OLAP_PAGE_POOL_SIZE is greater than available memory, OLAP session initialization will fail.
For performance reasons, it is generally preferable to use a small OLAP paging cache and a larger
DB_CACHE_SIZE. An OLAP paging cache of 4 MB is fairly typical, with 2 MB used for systems with limited memory resources.