What would be your next step to avoid this event in future?

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?

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.
Increase the value of the DB_WRITER_PROCESSES parameter.

C.
Set the USE_INDIRECT_DATA_BUFFERS parameter to TRUE.

D.
Increase the value of the DB_FILE_MULTIBLOCK_READ_COUNT parameter.

Show Hint

Leave a Reply 1

Your email address will not be published. Required fields are marked *

mr_tienvu

mr_tienvu

I agree with the answer. B

Reply