Which statements about the MEMORY_TARGET initialization parameter are true?

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

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

Show Hint

Leave a Reply 1

Your email address will not be published. Required fields are marked *

Eamon

Eamon

wow, B is actually also correct. you can find this snippet of information hidden in the documentation at
http://oracle.su/docs/11g/server.112/e10804/planned.htm#CJAGABGJ
If …
You omit MEMORY_MAX_TARGET
AND …
You omit MEMORY_TARGET
THEN …
The initialization parameters are left at their default values (0) and Oracle Database does not automatically tune memory

Reply