RE: comments on forcedirectio

  • From: "Reidy, Ron" <Ron.Reidy@xxxxxxxxxxxxxxxxxx>
  • To: <geraldine_2@xxxxxxxxxxx>, <Oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 29 Apr 2005 16:52:18 -0600

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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of
Sent: Friday, April 29, 2005 4:48 PM
To: Oracle-l@xxxxxxxxxxxxx
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 databases on SUN StorEdge T4 and NetApp.




This electronic message transmission is a PRIVATE communication which =
information which may be confidential or privileged. The information is =
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, =
or use of the contents of this information is prohibited. Please notify =
sender  of the delivery error by replying to this message, or notify us =
telephone (877-633-2436, ext. 0), and then delete it from your system.


Other related posts: