Oracle
1Z0-054 · Question #75
Examine the following information from the AWR report: Top 5 Timed Events ~~~~~~~~~~~~~~~~~~ % Total Event Waits Time (s) Call Time…
The correct answer is D. too many index range scans occurring which refers to blocks not in the database buffer cache. See the full explanation below for the reasoning.
Question
Examine the following information from the AWR report:
Top 5 Timed Events ~~~~~~~~~~~~~~~~~~ % Total Event Waits Time (s) Call Time -------------------------------------- ------------ ----------- ------- -- CPU time 559 88.80 log file parallel write 2,181 28 4.42 SQL*Net more data from client 516,611 27 4.24 db file parallel write 13,383 13 2.04 db file sequential read 563 2 .27 Which could cause waits on the db file sequential read event?
Options
- Atoo many full table scans
- Btoo large a database buffer cache
- Ctoo many waits occurring while reading multiple blocks synchronously
- Dtoo many index range scans occurring which refers to blocks not in the database buffer cache
How the community answered
(39 responses)- A8% (3)
- B15% (6)
- C5% (2)
- D72% (28)
Community Discussion
No community discussion yet for this question.