| action taken on scatterds read [message #317268] |
Wed, 30 April 2008 05:38  |
gopu_g
Messages: 54
Registered: March 2008
Location: mumbai
|
Member |
|
|
Dear all,
I would like RAISE A Question on Scattered read.
The parameter which we get in v$systen_event views, db file scattered read what action need to take on this parameter and whaty is the couse of this parameter giving values "Total Waits" in v$system _wait view.
Thanks in advance
|
|
|
|
|
|
|
|
|
|
| Re: action taken on scatterds read [message #317388 is a reply to message #317302] |
Wed, 30 April 2008 23:00  |
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
|
Senior Member |
|
|
Scattered reads are typically the result of a Full Table Scan.
Sequential Reads are typically the result of an Index Scan.
Full Table Scans are not always bad. If they are caused by an ETL or batch job processing large volumes of data, they are probably good. If your statistics were isolated to a period where only OLTP users were on the system, then a high Scattered Reads probably would indicate a problem.
Ross Leishman
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
