Oracle
1Z0-067 · Question #212
During the day, your database must support an OLTP workload that requires a large database buffer cache. At night, it must support batch jobs that require a higher value to be set for large pool…
The correct answer is B. Enable AMM and set the PRE_PAGE_SGA initialization to TRUE. See the full explanation below for the reasoning.
Question
During the day, your database must support an OLTP workload that requires a large database buffer cache. At night, it must support batch jobs that require a higher value to be set for large pool. What must you do to allow the memory pools to change size automatically as required? (Choose the best answer.)
Options
- AEnable AMM and set the SGA_TARGET initialization parameter to a nonzero value.
- BEnable AMM and set the PRE_PAGE_SGA initialization to TRUE.
- CEnable Automatic Memory Management (AMM) and set the PGA_TARGET initialization parameter
- DEnable AMM and set the PGA_TARGET initialization parameter to a nonzero value.
How the community answered
(26 responses)- A8% (2)
- B77% (20)
- C12% (3)
- D4% (1)
Community Discussion
No community discussion yet for this question.