Oracle
1Z0-054 · Question #60
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…
The correct answer is D. 1) % Non-Parse CPU is low and Soft Parse % is also low in the EFFICIENCY Exhibit. This shows. See the full explanation below for the reasoning.
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 are 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. Identify the option that has the correct answers for the questions given below: 1) Which factor indicates the main problem? 2) What is the main problem? 3) What solution would you recommend?
Exhibits
Options
- A
- The Exhibit DBTIME shows that the DB CPU event consumed very high % DB Time.
- B
- hard parse elapsed time has the majority time in parse time elapsed, which is shown in the
- C
- sql execute elapsed time and parse time elapsed are consuming very high % DB Time in the
- D
- % Non-Parse CPU is low and Soft Parse % is also low in the EFFICIENCY Exhibit. This shows
How the community answered
(54 responses)- A4% (2)
- B15% (8)
- C7% (4)
- D74% (40)
Community Discussion
No community discussion yet for this question.