You work as a database administrator to manage an online transaction processing (OLTP)
system.The application code was recently tuned for optimum performance and users
acknowledged the performance improvement. However, the users are now again complaining that
the application response time has gone down considerably.
You used a few queries to investigate the problem and a couple of important queries are shown in
the Exhibit. View the Exhibit and analyze the output shown.
Which actions would improve the performance? (Choose all that apply.)
A.
increasing the number database writers
B.
decreasing the number of database writers
C.
increasing the size of the database buffer cache
D.
decreasing the size of the database buffer cache
E.
decreasing the value set to the FAST_START_MTTR_TARGET parameter
A is right. because free buffer wait is high
B is wrong.
C is right. hit ratio is low
D is wrong
E is wrong