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: comments on forcedirectio

RE: comments on forcedirectio

From: Reidy, Ron <Ron.Reidy_at_arraybiopharma.com>
Date: Fri, 29 Apr 2005 16:52:18 -0600
Message-ID: <17CAB0BF27BCFC47B0E4554A0E2F962B43966A@fiji.arraybp.com>


Not sure on this one, but I think using this on NetApp will corrupt your = datafiles (worst case) or just cause your instance to crash at random = times (best case).



Ron Reidy
Lead DBA
Array BioPharma, Inc.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of geraldine_2_at_comcast.net
Sent: Friday, April 29, 2005 4:48 PM
To: Oracle-l_at_freelists.org
Subject: comments on forcedirectio

I've read articles that encourages the use of forcedirectio on redo logs = but discourages on oracle datafiles. With my limited understanding on = the forcedirectio option, I believe it should be used on Oracle = datafiles to eliminate double buffering. The use of forcedirectio should = improve database performance.=20
Are there any reasons why the option should not be used on Oracle = datafiles? Does the use of the option depends on the type of storage = array? We have 9.2.0.4 databases on SUN StorEdge T4 and NetApp.

Thanks.

Geraldine

--

http://www.freelists.org/webpage/oracle-l

This electronic message transmission is a PRIVATE communication which = contains
information which may be confidential or privileged. The information is = intended=20
to be for the use of the individual or entity named above. If you are = not the=20
intended recipient, please be aware that any disclosure, copying, = distribution=20
or use of the contents of this information is prohibited. Please notify = the
sender of the delivery error by replying to this message, or notify us = by
telephone (877-633-2436, ext. 0), and then delete it from your system.

--

http://www.freelists.org/webpage/oracle-l Received on Fri Apr 29 2005 - 18:54:46 CDT

Original text of this message

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