Oracle
1Z0-054 · Question #78
1Z0-054 Question #78: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-054 to reveal the answer and full explanation for question #78. The question stem and answer options stay visible for context.
Question
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.)
Exhibit
Options
- Aincreasing the number database writers
- Bdecreasing the number of database writers
- Cincreasing the size of the database buffer cache
- Ddecreasing the size of the database buffer cache
- Edecreasing the value set to the FAST_START_MTTR_TARGET parameter
Unlock 1Z0-054 to see the answer
You've previewed enough free 1Z0-054 questions. Unlock 1Z0-054 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.