Initialization Parameters for Oracle OLAP

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.

Table 6-1 Database Performance Initialization Parameter Settings

Parameter	Setting
db_cache_size	Half of physical memory
parallel_max_servers	The number of processors minus one 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.
sessions	2.5 * maximum number of OLAP users

See Also: Oracle9i SQL Reference for information about these parameters.

Take the following steps to set system parameters:

1. Open the initsid.ora parameters file in a text editor.

   The parameters file is located in $ORACLE_HOME/admin/sid/pfile, where sid is the system identifier as defined in $ORACLE_HOME/network/admin/tnsnames.ora.

2. Add or change the settings in the file.

   For example, you might enter a command like this so that Oracle can write files to the OraHome1/olap directory:

   UTL_FILE_DIR=/users/oracle/OraHome1/olap

3. Stop and restart the database, using commands such as the following. Be sure to identify the parameters file in the STARTUP command.

   sqlplus '/ as sysdba'
   shutdown immediate
   startup pfile=/users/oracle/OraHome1/admin/rel9dw/pfile/initrel9dw.ora