54.Automatic Shared Memory Management (ASMM) has been enabled for your database instance. The initia

最新推荐文章于 2022-11-12 14:33:38 发布

今年我18

最新推荐文章于 2022-11-12 14:33:38 发布

阅读量881

点赞数

CC 4.0 BY-SA版权

分类专栏： 1z0-052 文章标签： 1z0-052

本文链接：https://blog.youkuaiyun.com/dwj19830118/article/details/52006887

1z0-052 专栏收录该内容

187 篇文章

订阅专栏

本文探讨了Automatic Shared Memory Management (ASMM)环境下DB_CACHE_SIZE参数的作用。当ASMM启用后，若手动设置了DB_CACHE_SIZE参数，则该参数将作为数据库缓冲区缓存的最小分配内存值。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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 33 / 86
The safer , easier way to help you pass any IT exams.
distribution during ASMM is set to 100 MB.
答案：A
解析：启动asmm后DB_CACHE_SIZE是自动管理的，不需要设置，如果设置的话，那是保证分配的最小值
具体内容可以参考53题