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@xxxxxxxxxxxxx
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
-----------------------------------------------------------------

Other related posts: