The following table lists the parameters and recommended values for an existing Oracle database server.
Parameter |
Value |
---|---|
DB_BLOCK_SIZE |
8192 |
OPTIMIZER_MODE |
ALL_ROWS |
CURSOR_SHARING |
FORCE |
PROCESSES |
500 |
SGA_TARGET |
1200 MB |
PGA_AGGREGATE_TARGET |
400 MB |
MEMORY_TARGET |
1600 MB NOTE: If MEMORY_TARGET is defined, you do not need to define SGA_TARGET and PGA_AGGREGATE_TARGET. |
Parent Topic |