Re: db file scattered reads
Date: Wed, 1 Dec 2010 14:26:25 -0600
Message-ID: <AANLkTik0y9Zfd6nEsYgZN-yLz0DGEBQguUAmaTTmWjHT_at_mail.gmail.com>
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_at_sanfranmail.com> 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 -- http://www.freelists.org/webpage/oracle-lReceived on Wed Dec 01 2010 - 14:26:25 CST