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.



Leave a Reply 0

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