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
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 //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
