The following two tables recommend Oracle parameter settings for use with Atlas Hub databases.
| 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 |
| 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. |