QUESTION 191-SGA TARGET shared pool

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