Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Direct I/O, better performance?

Re: Direct I/O, better performance?

From: uberdba <uberdba_at_gmail.com>
Date: Tue, 19 Oct 2004 15:22:37 -0400
Message-ID: <80dc5c1a04101912224d497a24@mail.gmail.com>


I believe you are bypassing the filesystem buffering now, so you may need to adjust the caching and multiblock read parameters.

-Daniel

On Tue, 19 Oct 2004 14:16:02 -0500, Roger Xu <roger_xu_at_dp7uptx.com> wrote:
> Hi,
>
> We are running Solaris 9 with UFS on Oracle 9.2.0.4.0.
> We switched to direct I/O and did not see a better performance
> as far as updating statistics concerned. Why?
>
> It used to take us 22 hours to update statistics for all tables,
> but now 31 hours.
>
> Thanks,
> Roger Xu
> Database Administrator
> Dr Pepper Bottling Company of Texas
> (972)721-8337
>
> This e-mail is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Any review, dissemination, copying, printing or other use of this e-mail by persons or entities other than the addressee is prohibited. If you have received this e-mail in error, please contact the sender immediately and delete the material.
> ____________________________________________________________________
> This email has been scanned for all viruses by the MessageLabs Email Security System. Any questions please call 972-721-8257 or email your request to tech_support_at_dp7uptx.com.
> --
> http://www.freelists.org/webpage/oracle-l
>

-- 
-Daniel
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Oct 19 2004 - 14:19:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US