Additional settings for the Oracle database instance
For optimal performance, configure the INIT<INSTANCE_NAME>.ORA file to use these parameters and values for Oracle databases.
| Parameter | Description | Value |
|---|---|---|
OPEN_CURSORS |
Number of open cursors |
Greater than or equal to 2000 |
SHARED_POOL_SIZE |
Shared pool size |
Greater than or equal to 90000000 |
LARGE_POOL_SIZE |
Large pool size |
Greater than or equal to 614400 |
PROCESSES |
Number of processes |
Greater than or equal to 500 |
LOG_BUFFER |
Log buffer |
Greater than or equal to 163840 |
DB_BLOCK_SIZE |
Database block size |
Greater than or equal to 8192 |
NLS_LENGTH_SEMANTICS |
NLS Length semantics |
CHAR |
SGA_MAX_SIZE |
SGA maximum size |
1 GB to n GB, depending on the amount of physical memory on your database server. If the server is running only this database, up to 80% of physical memory. |
SGA_TARGET |
SGA components total size |
1 GB to n GB, depending on the amount of physical memory on your database server. If the server is running only this database, up to 80% of physical memory. |
PGA_AGGREGATE_TARGET |
PGA target aggregate memory |
1 GB to n GB, depending on the amount of physical memory on your database server. If the server is running only this database, up to 80% of physical memory. |
cursor_sharing |
Cursor sharing |
exact |
timed_statistics |
Timed Statistics |
true |
optimizer_mode |
Optimizer mode |
All_rows |
| MAXEXTENTS | Max extents |
Unlimited |