Oracle
1Z0-054 · Question #208
While reviewing the Top 5 Timed Events section in the Automatic Workload Repository report, you notice that the db file scattered read and db file sequential read events appear in the list. Which…
The correct answer is A. SQL statements performing frequent full table scans C. SQL statements performing frequent fast full index scans. See the full explanation below for the reasoning.
Question
While reviewing the Top 5 Timed Events section in the Automatic Workload Repository report, you notice that the db file scattered read and db file sequential read events appear in the list. Which two reasons could have caused these wait events? (Choose two.)
Options
- ASQL statements performing frequent full table scans
- Btablespaces using manual segment space management
- CSQL statements performing frequent fast full index scans
- Dexcessive writes due to an aggressive checkpointing policy
How the community answered
(51 responses)- A80% (41)
- B8% (4)
- D12% (6)
Community Discussion
No community discussion yet for this question.