702. View the Exhibit and examine the parameter settings in your server-side parameter file (SPFILE).

When you tried to start the database instance, you received the following error:

Why did the instance fail to start?
A.Because the PGA_AGGREGATE_TARGET parameter is not set
B.Because the STATISTICS_LEVEL parameter is set to BASIC
C.Because MEMORY_TARGET and MEMORY_MAX_TARGET cannot be equal
D.Because both the SGA_TARGET and MEMORY_TARGET parameters are set.
Answer:B
参考:
http://docs.oracle.com/cd/E11882_01/server.112/e25494/memory.htm#ADMIN11207
在AMM模式时设置SGA_TARGET和或PGA_AGGREGATE_TARGET,只表示SGA和或PGA内存的最小值。
ASMM模式时STATISTICS_LEVEL不能设置为BASIC。因为需要收集内存使用信息。
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/81227/viewspace-2122336/
,如需转载,请注明出处,否则将追究法律责任。