Which two statements are true regarding the SGA_TARGET initialization parameter? (Choose two.)
A.
It can be increased up to the value of the SGA_MAX_SIZE parameter.
B.
Increasing the value of the SGA_TARGET parameter distributes the increased memory among all
the autotuned components.
C.
Reducing the value of the SGA_TARGET parameter deallocates memory from both autotuned and
manually sized components.
D.
Increasing the value of SGA_TARGET up to the value of SGA_MAX_SIZE disables the automatic
shared memory management feature.
About Automatic Shared Memory Management
Automatic Shared Memory Management simplifies SGA memory management. You specify the total amount of SGA memory available to an instance using theSGA_TARGET initialization parameter and Oracle Database automatically distributes this memory among the various SGA components to ensure the most effective memory utilization.
Dynamic Modification of SGA_TARGET
The SGA_TARGET parameter can be dynamically increased up to the value specified for the SGA_MAX_SIZE parameter, and it can also be reduced. If you reduce the value of SGA_TARGET, the system identifies one or more automatically tuned components for which to release memory. You can reduce SGA_TARGET until one or more automatically (NOT MANUALLY) tuned components reach their minimum size.
For example, suppose you have an environment with the following configuration:
SGA_MAX_SIZE = 1024M
SGA_TARGET = 512M
DB_8K_CACHE_SIZE = 128M
Reduce SGA_TARGET – identifies automatically tuned components (not manual tuned) for which to release memory. C is wrong
Automatic Shared Memory Management is automatic, not manual.
http://docs.oracle.com/cd/E11882_01/server.112/e25494/memory.htm#ADMIN11215
SGA MAX – INCREASE – INCREASE – MEMORY