Recommended Initialization Parameters

The following two tables recommend Oracle parameter settings for use with StarTeam Server databases.

Table 1. Common Database Configuration Parameters
Parameter Recommended Value
Compatible

10gR2: 10.2.0

11g: 11.1.0.0.0

Cursor_sharing

10gR2: Force

11g: Force

Log_checkpoint_interval Greater than the redo log size
Log_checkpoint_timeout 0
Workarea_size_policy Auto
Db_block_size 16384 (16k)
Db_file_multi_block_read_count 16
Optimizer_mode first_rows
Timed_statistics True
Open_cursors 400
Undo_management Auto
Undo_tablespace (Name of the undo tablespace)
Undo_retention 28800
Processes 250
Statistics_level Typical
Table 2. Database parameters based on total memory
Total Memory Recommended 10gR2 Settings Recommended 11g Settings
1 GB

SGA_TARGET = (Total Physical Memory * 80%) * 60%.

We assume that 20% of the total memory will be used by the OS.

Statistics level should be TYPICAL or ALL.

LOG_BUFFER = 524288.

PGA_AGGREGATE_TARGET = (Total Physical Memory * 80%) * 30%.

30% of the non-OS available memory. This is the starting value. This may need to be adjusted upwards.

MEMORY_TARGET = Total Physical Memory * 75%.

We assume that 20% of the total memory will be used by the OS.

The Oracle instance should be running on a dedicated machine.

Statistics level should be TYPICAL or ALL.

LOG_BUFFER = 524288.

2 GB

SGA_TARGET = (Total Physical Memory * 80%) * 60%.

We assume that 20% of the total memory will be used by the OS.

Statistics level should be TYPICAL or ALL.

LOG_BUFFER = 1048576.

PGA_AGGREGATE_TARGET = (Total Physical Memory * 80%) * 30%.

We assume that 20% of the total memory will be used by the OS. This is the starting value. This may need to be adjusted upwards.

MEMORY_TARGET = Total Physical Memory * 75%.

We assume that 20% of the total memory will be used by the OS.

The Oracle instance should be running on a dedicated machine.

Statistics level should be TYPICAL or ALL.

LOG_BUFFER = 1048576.

4 GB

SGA_TARGET = (Total Physical Memory * 80%) * 60%.

We assume that 20% of the total memory will be used by the OS.

Statistics level should be TYPICAL or ALL.

LOG_BUFFER = 1048576.

PGA_AGGREGATE_TARGET = (Total Physical Memory * 80%) * 30%.

We assume that 20% of the total memory will be used by the OS. This is the starting value. This may need to be adjusted upwards.

MEMORY_TARGET = Total Physical Memory * 75%.

We assume that 20% of the total memory will be used by the OS.

The Oracle instance should be running on a dedicated machine.

Statistics level should be TYPICAL or ALL.

LOG_BUFFER = 1048576.