Oracle
1Z0-064 · Question #26
Examine the Time Model Statistics section of an AWR report: Which two inferences can be definitely derived from this section? (Choose two.)
The correct answer is D. New child cursors were created because of new bind values or usage of literal values as well as E. The DB CPU time was not spent exclusively for processing SQL statements. See the full explanation below for the reasoning.
Question
Examine the Time Model Statistics section of an AWR report:
Which two inferences can be definitely derived from this section? (Choose two.)
Exhibit
Options
- AThe available CPU resources were not utilized to their maximum capacity.
- BAll sequence numbers used during this AWR time interval were cached.
- CA large number of connected user sessions were idle.
- DNew child cursors were created because of new bind values or usage of literal values as well as
- EThe DB CPU time was not spent exclusively for processing SQL statements.
How the community answered
(20 responses)- A5% (1)
- C10% (2)
- D85% (17)
Community Discussion
No community discussion yet for this question.