Re: db file scattered read

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 paying particular attention to the most expensive SQL, and look for the full table scans. Something is doing full table scan.

-- 
Mladen Gogala
Oracle DBA
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------