OIM 11g R2 – Recommended Initial Settings for Oracle Database 11g

Parameter Recommended Initial Settings for Oracle Database 11g
db_block_size 8192
memory_target Using Automatic Memory Management feature in Oracle Database 11g, the MEMORY_TARGET and MEMORY_MAX_TARGET parameters can be used to manage the SGA and PGA together.

Recommended value is 3 GB.

When considering MEMORY_TARGET for managing the database memory components, SGA_TARGET and PGA_AGGREGATE_TARGET can be left unallocated, which is 0.

db_keep_cache_size 800M
log_buffer 15 MB
cursor_sharing FORCE
open_cursors 500
session_cached_cursors 500
query_rewrite_integrity TRUSTED
query_rewrite_enabled TRUE
db_file_multiblock_read_count 16
db_writer_processes 2
processes Based on connection pool settings

 

Leave a Reply

Your email address will not be published. Required fields are marked *