54. Automatic Shared Memory Management (ASMM) has been enabled for your database instance. The
initialization parameters for the components that are managed by ASMM are not set. After observing the
effects of ASSM, you executed the following command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M;
Which statement is true in this scenario?
A.The minimum memory size for the database buffer cache is set to 100 MB.
B.The maximum memory size that can be obtained by the database buffer cache during ASMM is set to
100 MB.
C.The minimum memory size allocated for a server process in the database buffer cache in dedicated
mode is set to 100 MB.
D.The maximum memory size from the database buffer cache that can be released for dynamic
distribution during ASMM is set to 100 MB.
Answer: A
在Automatic Shared Memory Management (ASMM)环境下,通过设置DB_CACHE_SIZE为100M来调整数据库缓冲区缓存的最小内存大小。当启用ASMM后,可以观察其效果并进一步调整各内存组件的分配值。
1091

被折叠的 条评论
为什么被折叠?



