RE: db file scattered reads
- From: "Blanchard, William G" <William.Blanchard@xxxxxxxxxxxxx>
- To: <lyallbarbour@xxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 1 Dec 2010 14:57:32 -0600
I had one table, along with indexes, that I placed in a keep pool
because of the number of db file read waits.
WGB
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
lyallbarbour@xxxxxxxxxxxxxxx
Sent: Wednesday, December 01, 2010 2:04 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: db file scattered reads
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
_____________
The information contained in this message is proprietary and/or confidential.
If you are not the intended recipient, please: (i) delete the message and all
copies; (ii) do not disclose, distribute or use the message in any manner; and
(iii) notify the sender immediately. In addition, please be aware that any
message addressed to our domain is subject to archiving and review by persons
other than the intended recipient. Thank you.
_____________
Other related posts:
