Examine the parameters set for your database instance:
You upgrade your database to Oracle Database 12c. The database supports a mixed
workload and works with different workloads at different times. You notice in an ADDM
report that the shared pool is inadequately sized. You resize the shared pool by decreasing
the sizes of other pools, which results in inadequate sizes for other pools. You want to
automate the sizing of SGA components. Which two actions should you perform?(Choose
two.)
A.
Set theSGA_TARGETparameter equal toSGA_MAX_SIZE.
B.
Set theSGA_TARGETparameter to the sum ofDB_CACHE_SIZE,SHARED_POOL,
andLARGE_POOL_SIZE.
C.
Set theMEMORY_MAX_TARGETparameter to the sum
ofDB_CACHE_SIZE,SHARED_POOL, andLARGE_POOL_SIZE.
D.
SetDB_CACHE_SIZE,SHARED_POOL, andLARGE_POOL_SIZEto their minimum
required values.
E.
Set thePGA_AGGREGATE_TARGETparameter to0andtheSGA_TARGETparameter
to1.5G.
A and B are ok.
A,d
in case of D you don’t automate the sizing of SGA pools.
misunderstood the question… two unseparated actions required… A,D
AD
B would lock to a too small size
C is joke as E