What would you do to avoid the wait event in the new database?

In an online transaction processing (OLTP) database, a large number of concurrent users are performing small transactions on a specific schema. You observe the statistics and find that total_waits for buffer busy event is increasing significantly. You are in the process of creating another OLTP database with similar workload. What would you do to avoid the wait event in the new database?

In an online transaction processing (OLTP) database, a large number of concurrent users are performing small transactions on a specific schema. You observe the statistics and find that total_waits for buffer busy event is increasing significantly. You are in the process of creating another OLTP database with similar workload. What would you do to avoid the wait event in the new database?

A.
Consider setting a larger value for DB_BLOCK_SIZE for the database.

B.
Consider setting a smaller value for DB_BLOCK_SIZE for the database.

C.
Consider setting a larger value for the DB_CACHE_SIZE parameter for the database.

D.
Consider using the DB_BLOCK_BUFFERS parameter instead of the DB_CACHE_SIZE parameter for the database.



Leave a Reply 1

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


seenagape

seenagape

I agree with the answer. B