Page History
...
| Parameter | Value | Improvement / Remarks |
|---|---|---|
log_checkpoint_timeout | 900 | |
open_cursors | 300 | Verify that you have enough open cursors for the application to execute. |
Processes | 300 | Verify that you have enough processes for the application to execute. |
Table 4 Oracle 9i parameters
...
DB-cache_advice
...
Verify that this parameter is set to off because the default value is on.
...
Table 5 Oracle 10g parameter
...
sga_target
...
Automatic memory management. One quarter of the physical memory.
...
Replaces the following parameters:
- db_cache_size
- shared_pool_size
- large_pool_size
- java_pool_size
Verify that they are initialized with either 0 or the minimum value you need.
INIT.ORA example
The following is an example of the init.ora file for an Oracle 12.2 instance.
...
The following table shows the default extents sizes.
Table 64 Default extents sizes
| Tablespace | Size |
|---|---|
| Large table | 2 MB |
| Medium table | 512 KB |
| Small table | 80 KB |
| Large index | 1 MB |
| Medium index | 256 KB |
| Small index | 80 KB |
...