Which statement is true about the memory management for the newly started database instance?
A. MEMORY_TARGET defines the maximum limit for SGA_TARGET
B. SGA_TARGET and PGA_AGGREGATE_TARGET combined will never grow beyond 500M
C. The value for MEMORY_MAX_TARGET is the sum of SGA_TARGET and PGA_AGGREGATE_TARGET
D. SGA_TARGET and PGA_AGGREGATE_TARGET will keep growing till a maximum of 300M and 70M, respectively
Answer:A
Which statement is true about the memory management for the newly started database instance?
A. MEMORY_TARGET defines the maximum limit for SGA_TARGET B. SGA_TARGET and PGA_AGGREGATE_TARGET combined will never grow beyond 500M C. The value for MEMORY_MAX_TARGET is the sum of SGA_TARGET and PGA_AGGREGATE_TARGET D. SGA_TARGET and PGA_AGGREGATE_TARGET will keep growing till a maximum of 300M and 70M, respectively
Explanation: In a text initialization parameter file, if you omit the line for MEMORY_MAX_TARGET and include a value for MEMORY_TARGET, the database automatically sets MEMORY_MAX_TARGET to the value of MEMORY_TARGET. If you omit the line for MEMORY_TARGET and include a value for MEMORY_MAX_TARGET, the MEMORY_TARGET parameter defaults to zero. After start-up, you can then dynamically change MEMORY_TARGET to a nonzero value, provided that it does not exceed the value of MEMORY_MAX_TARGET.