Re: db file sequential/scattered read - physical or logical io or both?
From: Greg Rahn <greg_at_structureddata.org>
Date: Mon, 14 Jun 2010 07:01:31 -0700
Message-ID: <AANLkTin1hQvMhUQJ5vxNvVNicNy2YqQX26BaGpXy3TXI_at_mail.gmail.com>
Then I would suggest looking at the SQL and execution plan first to determine if the best plan is being used. There is no sense in worrying about how fast/slow IO is if the plan is not the best one.
Date: Mon, 14 Jun 2010 07:01:31 -0700
Message-ID: <AANLkTin1hQvMhUQJ5vxNvVNicNy2YqQX26BaGpXy3TXI_at_mail.gmail.com>
Then I would suggest looking at the SQL and execution plan first to determine if the best plan is being used. There is no sense in worrying about how fast/slow IO is if the plan is not the best one.
On Mon, Jun 14, 2010 at 5:36 AM, Oracle Dba Wannabe
<oracledbawannabe_at_yahoo.com> wrote:
> The report itself is actually a problem - to resolve it I understand I need to address the number of i./o's issued by it.
-- Regards, Greg Rahn http://structureddata.org -- http://www.freelists.org/webpage/oracle-lReceived on Mon Jun 14 2010 - 09:01:31 CDT