28. You enabled Automatic Shared Memory Management. The initializatio
n parameters are set as shown below:
SGA_TARGET= 10GB
SGA_MAX_SIZE = 14GB
STREAMS_POOL_SIZE = 1GB
SHARED_POOL_SIZE = 3GB
Which two statements are correct in this scenario? (Choose two.)
A. A maximum of 3 GB can be allocated to shared pool.
B. The value for SGA_TARGET can be increased up to a maximum of 14 GB
C. A total of 14 GB memory will be allocated to the automatically tun
ed memory components.
D. Increasing the value for SGA_TARGET will automatically increase th
e memory allocated for STREAMS_POOL_SIZE.
E. Increasing the value for SGA_TARGET to 12 GB will automatically in
crease the memory allocated to autotuned parameters.
F. Reducing the value for SGA_TARGET to 9 GB will automatically decre
ase the memory allocated to shared pool from 3 GB to 2 GB.
Answer: B, E
SHARED_POOL_SIZE 设置值后只会增加,不会减少
D选项，必要条件与充分条件。
D选项，必要条件与充分条件。
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/11312660/viewspace-717686/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
