Re: db file scattered read

  • From: Mladen Gogala <gogala@xxxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 6 Aug 2004 19:24:26 -0400

On 08/06/2004 07:07:56 PM, Lyndon Tiu wrote:
> Hello,

> "db file scattered read" is the top wait event and it uses up a large 
> proportion of the time > between each statspack.snap snapshots, what does 
> this mean?

It means that you have databases to tune before you sleep. You'll do so by 
particular attention to the most expensive SQL, and look for the full table 
Something is doing full table scan.
Mladen Gogala
Oracle DBA
Please see the official ORACLE-L FAQ:
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
Archives are at
FAQ is at

Other related posts: