You are working on a database that was upgraded to Oracle Database 11g from Oracle Database
9i. An ADDM finding in this database says that the shared pool is inadequately sized, as shown in the Exhibit.
You diagnosed that this is due to different kinds of workloads and this occurs only during peak
hours. The following are the related parameter settings:
SQL> show parameter sga
name TYPE VALUE
—————————— ————— —————–
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 300M
sga_target big integer 0
SQL> show parameter target
name TYPE VALUE
—————————— ————— —————–
…..
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 within the SGA depending on the workloads. Which two options would solve this problem? (Choose two.)
A.
Set the SGA_TARGET parameter to 300M.
B.
Set the SGA_MAX_SIZE parameter to 400M.
C.
Set the MEMORY_MAX_TARGET and MEMORY_TARGET parameters to 400M.
D.
Set the MEMORY_MAX_TARGET and MEMORY_TARGET parameters to 100M.
E.
Set the PGA_AGGREGATE_TARGET parameter to 200M and the SGA_MAX_SIZE parameter
to 400M.
set SGA_TARGET will use ASMM
set MEMORY_MAX_SIZE and MEMORY_TARGET will use AMM
A. C. are correct