Oracle
1Z0-054 · Question #3
You are working on an online transaction processing (OLTP) system. You detected free buffer waits events for your database instance running in a machine that has multiple CPUs. You increased the…
The correct answer is C. Increase the value of the DB_WRITER_PROCESSES parameter. See the full explanation below for the reasoning.
Question
You are working on an online transaction processing (OLTP) system. You detected free buffer waits events for your database instance running in a machine that has multiple CPUs. You increased the database buffer cache size as the first step. After a few hours of work on the database, further investigation shows that the same event is being recorded. What would be your next step to avoid this event in future?
Options
- ADecrease the value of the DBWR_IO_SLAVES parameter.
- BSet the USE_INDIRECT_DATA_BUFFERS parameter to TRUE.
- CIncrease the value of the DB_WRITER_PROCESSES parameter.
- DIncrease the value of the DB_FILE_MULTIBLOCK_READ_COUNT parameter.
How the community answered
(35 responses)- A9% (3)
- B3% (1)
- C71% (25)
- D17% (6)
Community Discussion
No community discussion yet for this question.