Re: db file scattered reads
- From: Taral Desai <taral.desai@xxxxxxxxx>
- To: lyallbarbour@xxxxxxxxxxxxxxx
- Date: Wed, 1 Dec 2010 14:26:25 -0600
Well when you see ASH/AWR report it has to display some information as top
five even you are ideal. Other point if my query has to read all blocks with
FTS then how can you avoid this. But one thing is if my query need some
little based on some condition and still i am scanning whole data then there
you can rewrite or do structure modification to improve this.
But, still we don't know what version you are what kind of storage. May be
storage, CPU or many factor involved in this can make this slow.
What do you mean by moving table into it's own tablespace isn't table are on
tablespaces.
On Wed, Dec 1, 2010 at 2:04 PM, <lyallbarbour@xxxxxxxxxxxxxxx> wrote:
> Hello everyone,
> From what i understand in my reading of this wait event, it happens the
> most with Fast Full Table Scans. As we all know, FFTS's aren't necessarily
> a bad thing. Looking through ADDM's and ASH reports from one of our
> databases, db file scattered reads on one table is the main culprit for the
> bottlenecks on this system. This is an off the self application that i
> can't touch, so the only SQL tuning i can do is with SQL Profiles. Is there
> anything i can do under the scenes to release some of this bottleneck? Move
> the table into it's own tablespace? Change the storage settings? That's
> one thing i can't find through google, is what to do if you get db file
> scattered reads. I'm still waiting for my tuning guide from Rampant, it's
> on backorder...
>
> Thanks,
> Lyall
>
>
>
--
Thanks & Regards,
Taral Desai
Other related posts:
