Oracle database performance tuning

Oracle recommends the generic Oracle database optimizations for Health Record Locator and on the specific database behavior.

Table 2-10 Oracle database performance parameters

Parameter	Value
db_cache_size	1 GB
memory_target	8 GB
memory_max_target	8 GB
log_buffer	3 MB
LARGE_POOL_SIZE	100 MB
PGA_AGGREGATE_TARGET	2 GB
SGA_MAX_SIZE	4 GB
SGA_TARGET	4 GB
SHARED_POOL_SIZE	1 GB
processes	1200
session	1350
open_cursors	1200
java_pool_size	100 MB