053-414

By setting the value of MEMORY_TARGET to zero and setting the value of SGA_TARGET to a
nonzero value, you will enable which of the following memory-management options?
A. Automatic PGA Memory Management
B. Automatic SGA Memory Management
C. Automatic Shared Memory Management
D. Automatic Memory Management
E. Manual SGA Memory Management
F. None of the above

  The SGA_TARGET initialization parameter is used to set the total memory for the SGA for Automatic Shared Memory Management.
要从自动内存管理模式更改为 ASMM,请执行以下操作:
1. 将初始化参数 MEMORY_TARGET 设置为 0
ALTER SYSTEM SET MEMORY_TARGET = 0;
数据库将根据当前的 SGA 内存分配设置 SGA_TARGET
2. 将自动设置大小的 SGA 组件的值设置为 0。完成后,重新启动实例。

posted @ 2017-11-14 13:58  巴啦啦大魔王  阅读(112)  评论(0编辑  收藏  举报