The following table lists the parameters and recommended values for an existing Oracle database server:
Oracle requirements
Parameter |
Value |
|---|---|
DB_BLOCK_SIZE |
8192 |
OPTIMIZER_MODE |
ALL_ROWS |
CURSOR_SHARING |
FORCE |
PROCESSES |
300 |
Redolog groups |
3 |
Redolog size |
150 |
SGA_TARGET |
900 MB |
PGA_AGGREGATE_TARGET |
200 MB |
MEMORY_TARGET |
1100 MB (Oracle 11 and later only) |
Parent Topic |