Oracle Server Initialization Parameters Recommendations

The following sections describe how to configure the application's initialization parameters with an Oracle database. Modifying Oracle initialization parameters in the init<InstanceSid>.ora file. Refer to recommendations provided with your Oracle installation's default init.ora (located in $ORACLE_HOME/ srvm/admin/ typically)

Shared_pool_size Minimum size 150M

Shared_pool_reserved_size Minimum size 15M

Open_cursors Minimum 1500

Processes Minimum 100

Job_queue_processes Minimum 2

Sort_area_size = 1048576

Sort_area_retained_size= 1048576