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.