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?
A.
Decrease the value of the DBWR_IO_SLAVES parameter.
B.
Set the USE_INDIRECT_DATA_BUFFERS parameter to TRUE.
C.
Increase the value of the DB_WRITER_PROCESSES parameter.
D.
Increase the value of the DB_FILE_MULTIBLOCK_READ_COUNT parameter.
With Free Buffer wait, you have 2 solutions :
increased the database buffer cache size
or / and
Increase the value of the DB_WRITER_PROCESSES parameter
Free buffer wait is because no free buffer available. 2 reasons, one is too small, one is dirty buffer cleared too slow.
since buffer cache already increased, so C would be the answer.