OCP 1Z0 052 V9.02 177

177.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.  
Answer: AB  

http://docs.oracle.com/cd/E11882_01/server.112/e41573/memory.htm#PFGRF94255

7.1.3 Automatic Shared Memory Management

Automatic Shared Memory Management simplifies the configuration of the SGA. To use Automatic Shared Memory Management, set the SGA_TARGET initialization parameter to a nonzero value and set the STATISTICS_LEVEL initialization parameter to TYPICAL orALL. Set the value of the SGA_TARGET parameter to the amount of memory that you intend to dedicate for the SGA. In response to the workload on the system, the automatic SGA management distributes the memory appropriately for the following memory pools:

• Database buffer cache (default pool)

• Shared pool

• Large pool

• Java pool

• Streams pool

If these automatically tuned memory pools had been set to nonzero values, those values are used as minimum levels by Automatic Shared Memory Management. You would set minimum values if an application component needs a minimum amount of memory to function properly.

SGA_TARGET is a dynamic parameter that can be changed by accessing the SGA Size Advisor from the Memory Parameters SGA page in Oracle Enterprise Manager, or by querying the V$SGA_TARGET_ADVICE view and using the ALTER SYSTEM command. SGA_TARGETcan be set less than or equal to the value of SGA_MAX_SIZE initialization parameter. Changes in the value of SGA_TARGET automatically resize the automatically tuned memory pools.