193: In your running instance, some of the initialization parameters are
set as shown below:
SGA_MAX_SIZE = 14GB
DB_CACHE_SIZE = 1GB
SHARED_POOL_SIZE = 3GB
STATISTICS_LEVEL = BASIC
PGA_AGGREGATE_TARGET = 0
You plan to enable Automatic Shared Memory Management but you are not able
to set SGA_TARGET to a nonzero value. What could be the reason?
A.The STATISTICS_LEVEL initialization parameter is set to BASIC.
B.The PGA_AGGREGATE_TARGET initialization parameter is set to zero.
C.The SGA_MAX_SIZE initialization parameter is set to less than 20 GB.
D.The DB_CACHE_SIZE initialization parameter is set to less than 5 GB.
E.The SHARED_POOL_SIZE initialization parameter is set to a nonzero
value.
Answer: A
By default, SGA_TARGET is set to 0, which means that Automatic Shared
Memory Management is disabled and you must manually configure the database
memory.如果不为0,则自动管理内存
条件：Automatic Shared Memory Management requires that STATISTICS_LEVEL
be set to TYPICAL or ALL.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/11312660/viewspace-718264/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
