An Automatic Database Diagnostic Monitor (ADDM) finding in your production database reports that the shared pool is inadequately sized. You diagnose that this is due to the different kinds of workloads and this occurs only during peak hours.
The following are the parameter settings for the database instance:
NAME TYPE VALUE
---------------------------------------------- ------------------------- --------------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 300M
sga_target big integer 0
fast_start_mttr_target integer 0
memory_max_target big integer 0
memory_target big integer 0
pga_aggregate_target big integer 100M
sga_target big integer 0
You want to
balance the memory
between the
System Global Area (SGA)
components depending on the workload.
Which option would solve this problem?
A. setting the PGA_AGGREGATE_TARGET parameter to 200M and the SGA_MAX_SIZE parameter to 400M
B. setting the MEMORY_TARGET and SGA_MAX_SIZE parameters to 400M
C. setting the SGA_TARGET parameter to 300M
D. setting the SGA_MAX_SIZE parameter to 400M
Correct Answer:
C