Oracle initialization parameters are set at instance creation. During existing instance analysis, current initialization parameters are compared to a set of recommended values. The list of recommended initialization parameters exists in the XML file <PS_HOME>\misc\ocu\PS_INIT.XML where PS_HOME is the Primavera® Portfolio Management installation directory.
Parameter | Oracle 11g / 12c |
|---|---|
fixed_date | ' ' (empty string) |
nls_date_format | 'MM/DD/YYYY' |
nls_sort | BINARY |
The following are recommended, but optional:
Parameter | Oracle 11g / 12c |
|---|---|
audit_trail | NONE |
cursor_sharing | FORCE |
db_block_checking | FALSE |
db_cache_size | parameter does not exist |
db_file_multiblock_read_count | 8 |
disk_asynch_io | TRUE |
fast_start_mttr_target | 60 |
java_pool_size | 52428800 |
license_max_sessions | 0 or more than 100 |
open_cursors | more than or equals 30,000 |
Processes | more than or equals 400 |
session_cached_cursors | 50 |
sessions | more than or equals 445 |
shared_pool_size | parameter does not exist |
statistics_level | TYPICAL |
timed_statistics | TRUE |
Transactions | more than or equals 490 |
undo_management | AUTO |
workarea_size_policy | AUTO |
pga_aggregate_target | parameter does not exist |
sga_target | see calculated parameters below |
sga_max_size | see calculated parameters below |
cpu_count | see calculated parameters below |
compatible | 11.2.0.0 or 12.1.0.2 |
Calculated Parameters
Calculate following parameters:
- sga_target is max (512M, 0.7 x RAM)
- sga_max_size is max (512M, 0.7 x RAM)
- pga_aggregate_target is max (50M, 0.1 x RAM)
- cpu_count according to the number of processors
Oracle SP File
The Oracle Database Configuration Utility checks if the instance uses the sp file. In this case all initialization parameters are adjusted in the sp file using syntax:
alter system set <parametr> = <value> scope=spfile;
If the Oracle instance does not use the sp file, the Oracle Database Configuration Utility will update init.ora file. The search path for the init.ora file is as follows:
- ORA_ORCL_PFILE registry value
- <ORACLE_HOME>\database\init<SID>.ora
- Redirection (IFILE=) from <ORACLE_HOME>\database\init<SID>.ora
In both cases the database restart the database after updating the initialization parameters.