在ASMM（Automatic Shared Memory Management）环境下，为满足白天OLTP作业与夜间批处理作业的不同内存需求，通过设置SGA_TARGET初始化参数至非零值，实现系统自动优化内存组件配置，确保资源按需分配，避免内存溢出。
51. In a system, large online transaction processing (OLTP) jobs run during the daytime that require a
large database buffer cache. In the night, the system supports batch jobs that require a higher value to be
set for the large pool. You must simultaneously configure the memory components to accommodate the
peak requirement.
What would you do to automate this configuration for the memory components with change in mode of
working?
A.Set the SGA_TARGET initialization parameter to zero.
B.Set the PRE_PAGE_SGA initialization parameter to TRUE.
C.Set the MEMORY_MAX_TARGET initialization parameter to zero.
D.Set the SGA_TARGET initialization parameter to a nonzero value.
Answer: D
答案解析：
参考：http://blog.csdn.net/rlhua/article/details/12493791
再分享一下我老师大神的人工智能教程吧。零基础！通俗易懂！风趣幽默！还带黄段子！希望你也加入到我们人工智能的队伍中来！https://blog.csdn.net/jiangjunshow
扫一扫
826
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
