In Oracle 11g, by default which one of the following conditions implicitly enables Automatic PGA
Memory Management?
A.
Setting a nonzero value for SGA_TARGET
B.
Configuring Automatic Shared Memory Management
C.
Configuring Automatic Memory Management
D.
Setting a nonzero value for SGA_MAX_SIZE and PGA_AGGREGATE_TARGET
E.
None of the above
B is wrong. ASMM has no influence on Automatic PGA Memory Management. C is a correct answer. AMM implicitly activate Automatic PGA Memory Management.
Nope, B is correct.
http://docs.oracle.com/cd/E11882_01/server.112/e10897/instance.htm#ADMQS12038
When you enable automatic shared memory management, you also implicitly enable automatic PGA memory management. With automatic PGA memory management, you set a target size for the instance PGA. The database then tunes the size of the instance PGA to your target, and dynamically tunes the sizes of individual PGAs.
Ok , but WHY is C wrong? Isnt AMM doing the same thing?
When you enable automatic shared memory management, you also implicitly enable automatic PGA memory management. With automatic PGA memory management, you set a target size for the instance PGA. The database then tunes the size of the instance PGA to your target, and dynamically tunes the sizes of individual PGAs
A and B are equivalent.
Automatic Memory Management
Oracle strongly recommends the use of automatic memory management to manage the memory on your system. Automatic memory management enables Oracle Database to automatically manage and tune the instance memory. Automatic memory management can be configured using a target memory size initialization parameter (MEMORY_TARGET) and a maximum memory size initialization parameter (MEMORY_MAX_TARGET). The database tunes to the target memory size, redistributing memory as needed between the system global area (SGA) and the instance program global area (instance PGA). Before setting any memory pool sizes, consider using the automatic memory management feature of Oracle Database. If you must configure memory allocations, consider using the Memory Advisor for managing memory.
Answer is B
By default, Oracle 11g is configured for Automatic Memory Management. If you configure
Automatic Shared Memory Management and make no other changes, you will implicitly
enable Automatic PGA Memory Management. Setting SGA_TARGET to a nonzero value
doesn’t immediately enable Automatic Shared Memory Management because you may still
have Automatic Memory Management enabled. Setting the parameter SGA_MAX_SIZE to
nonzero puts a cap on manual SGA configuration, but again it does not implement Manual
Shared Memory Management.