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

本文探讨了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题
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值