Oracle 11G OCP 1Z0-053 151

（151）Which statements about the MEMORY_TARGET initialization parameter are true?(Choose all that apply.)

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.

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/17013648/viewspace-1258535/，如需轉載，請註明出處，否則將追究法律責任。