A. MEMORY_TARGET can be increased up to the value of MEMORY_MAX_TARGET,if MEMORY_MAX_TARGET is set to a value greater than zero
B. MEMORY_MAX_TARGET defaults to a value of zero if MEMORY_TARGET is not set
C. MEMORY_TARGET represents the total amount of memory that can be allocated to SGA and PGA memory structures.
D. MEMORY_TARGET is static and cannot be modified without shutting down the instance
答案：（A、B、C）
解析：
D（X），MEMORY_TARGET是可以动态修改的。
|
sys@TESTDB11>alter system set memory_target = 815M; System altered. |