Explain the wait events in statspack report 'db scattered read'?
- 1 Answers
- 672 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What degree do database administrators need?
A tablespace has a table with 30 extents in it. Is this bad? Why or why not.
If a tablespace has a default pctincrease of zero what will this cause (in relationship to the smon process)?
What do you understand by the term 'normalization'?
What are the types of locks in database?
What does the no logging option do? Why would we use it? Why would we be careful of using it?
How many redo logs should you have and how should they be configured for maximum recoverability?
How can you tell if a tablespace has excessive fragmentation?
What are four common errors found in an alert .log?
How can you find your id on a system?
Who is a database user?
What is oracle partial backup?
Oracle General 
