View Exhibit1 and Exhibit2 to examine the current memory allocation and parameter settings,
respectively. Why are advisors not available for the shared pool and the buffer cache?
Exhibit 1:
Exhibit 2:
A.
because the DB_CACHE_ADVICE parameter is set to OFF
B.
because Automatic Memory Management (AMM) is disabled for the database instance
C.
because Automatic Shared Memory Management (ASMM) is enabled for the database instance
D.
because the values for the DB_CACHE_SIZE and SHARED_POOL_SIZE parameters were not
set initially
Actually there is no correct answer. We have memory_target set so AMM is enabled not ASMM
I mean this screenshot is a contradictory with the parameter values
why ASMM was enable if sga_target set 0?
I think c is the correct answer.
The Oracle Automatic Shared Memory Management is a feature that automatically readjusts the sizes of the main pools (db_cache_size, shared_pool_size, large_pool_size, java_pool_size) based on existing workloads.
http://www.dba-oracle.com/t_automatic_shared_memory_management.htm