You switch from Automatic Memory Management(AMM) to Automatic Shared Memory Management(ASMM) by executing this statement:
alter system set memory_target = 0;
Next, you restart the instance and set these values:
alter system set sga_max_size = 10gb;
alter system set sga_target = 8gb;
alter system set shared_pool_size = 1gb;
How do the values of SGA_TARGET, SGA_MAX_SIZE, and SHARED_POOL_SIZE vary throughout the day?(Choose the best answer)
A. SGA_TARGET varies up to SGA_MAX_SIZE, where depends on the number of users running DML.
B. SGA_TARGET can fall below 8GB if the PGA is low on memory.
C. SGA_TARGET stays at 8GB, and SHARED_POOL_SIZE never is above 1GB.
D. SGA_TARGET stays at 8GB, and SHARED_POOL_SIZE never falls below 1GB.
Answer: D
题意是：参数设定后一天内，如何变化？
SGA_TARGET = 8GB, SHARED_POOL_SIZE >= 1GB来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/81227/viewspace-2124990/ ，如需转载，请注明出处，否则将追究法律责任。
