Adjusting memory parameters
Hi:
DB Version: 11.2.0.1.
Solaris Sparc 10 64bit
I am experiencing performance issues in database server with significant user I/O waits and overall I/O throughput. We started experiencing these following a migration of EVA storage (UFS to ZFS).
I generated report ADDM during the periods when system had issues and it suggested to increase sga_target and pga_aggregate_target values. I have revisited the initialization parameters related to memory and need your valuable suggestions regarding this matter. Here is the current setup of values:
MEMORY_MAX_TARGET=9728M
MEMORY_TARGET=0
SGA_TARGET=7584M
PGA_AGGREGATE_TARGET=2144M
SGA_MAX_SIZE=7680M
DB Version: 11.2.0.1.
Solaris Sparc 10 64bit
I am experiencing performance issues in database server with significant user I/O waits and overall I/O throughput. We started experiencing these following a migration of EVA storage (UFS to ZFS).
I generated report ADDM during the periods when system had issues and it suggested to increase sga_target and pga_aggregate_target values. I have revisited the initialization parameters related to memory and need your valuable suggestions regarding this matter. Here is the current setup of values:
MEMORY_MAX_TARGET=9728M
MEMORY_TARGET=0
SGA_TARGET=7584M
PGA_AGGREGATE_TARGET=2144M
SGA_MAX_SIZE=7680M
1