Examine the memory-related parameters set in the SPFILE of an Oracle database:Which statement is true?
Posted: Sun Jun 11, 2023 3:51 pm
Examine the memory-related parameters set in the SPFILE of an Oracle database:Which statement is true?
A. Only SGA components are sized automatically.
B. Memory is dynamically re-allocated between the SGA and PGA as needed.
C. The size of the PGA cannot grow automatically beyond 500 MB.
D. The value of the MEMORY_TARGET parameter cannot be changed dynamically.
A. Only SGA components are sized automatically.
B. Memory is dynamically re-allocated between the SGA and PGA as needed.
C. The size of the PGA cannot grow automatically beyond 500 MB.
D. The value of the MEMORY_TARGET parameter cannot be changed dynamically.