Oracle
1Z0-054 · Question #61
1Z0-054 Question #61: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-054 to reveal the answer and full explanation for question #61. The question stem and answer options stay visible for context.
Question
You work as a consultant DBA for various clients. A performance issue in one of the online transaction processing (OLTP) systems is reported to you and you received the Automatic Workload Repository (AWR) report generated in the database. The main sections of the AWR report is shown in the Exhibits. View the Exhibit named DBTIME and note % DB Time. View the Exhibit named TIMEMODEL and note what has contributed to % DB Time. View the Exhibit named EFFICIENCY and examine the various percentages shown. Which option describes the correct understanding of the main problem?
Options
- AThe Exhibit DBTIME shows that the DB CPU event consumed very high % DB Time, which
- Bsql execute elapsed time and parse time elapsed are consuming very high % DB Time in the
- Chard parse elapsed time has the majority time in parse time elapsed, which is shown in the
- D% Non-Parse CPU: and Soft Parse %: are low in the EFFICIENCY Exhibit, which shows that very
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.