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 database.

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 2000

SESSIONS

Number of sessions

Greater than or equal to 3500

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