Home > Monitoring and Tuning Oracl... > Setting Database Initializa...
![]() Previous |
![]() Next |
Table: Initial Settings for Database Parameters 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. You can monitor the effectiveness of these settings and adjust them as necessary.
To set the system parameters:
Open the init.ora
initialization file in a text editor.
Add or change the settings in the file, as described in Table: Initial Settings for Database Parameters.
Stop and restart the database.
On Windows, use the Services utility to stop and restart OracleService
.
On Linux, use commands like the following. Be sure to identify the initialization file in the STARTUP
command.
SQLPLUS '/ AS SYSDBA' SHUTDOWN IMMEDIATE STARTUP pfile=$ORACLE_BASE/admin/orcl/pfile/init.ora.724200516420
See Also:
|
Initial Settings for Database Parameters
Parameter | Default Value | Recommended Setting | Description |
---|---|---|---|
|
|
If you reduce this value to limit the maximum number of job slaves running on an instance, then calculate the following number of processes for use by OLAP: Number of CPUs, plus one additional process for every three CPUs; in a multi-core CPU, each core counts as a CPU For example, |
Controls the degree of parallelism in OLAP builds, as described in "Parallelism" |
|
|
|
Controls how the degree of parallelism is determined When set to |
|
Derived |
2.5 * maximum number of simultaneous OLAP users |
Provides sufficient background processes for each user |
|
( |
|
Specifies use of an undo tablespace |
|
Derived |
Name of the undo tablespace, which must be defined previously |
Identifies the undo tablespace defined for OLAP use, as shown in "Creating an Undo Tablespace for OLAP". |