Explain the wait events in statspack report 'db scattered read'?
- 1 Answers
- 671 Views
- I also Faced
- E-Mail Answers
Answer Posted / Shashi Bhushan Singh
'DB Scattered Read' wait event indicates that a SQL statement has to perform multiple reads from different blocks (scattered I/O) due to index full scans or hash joins. High occurrences of this wait event can be a sign of poor query optimization, excessive indexes, or I/O contention.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Please Help Members By Posting Answers For Below Questions
No New Questions to Answer in this Category !! You can
Post New Questions
Answer Questions in Different Category
