Re: NFS and direct IO

Is this 11g? If so, have you looked at using Direct NFS? If you do be sure to 
patch to the latest patches including one-offs that are for DNFS and your 
platform. 

We have seen significant performance gains with DNFS and Solaris and NetApp 
(around 25-30%).




jbj2

--

Jamey Johnston

On Apr 17, 2011, at 11:40 PM, kyle Hailey <kylelf@xxxxxxxxx> wrote:

> 
> I consider  CIO on AIX an optimization option and not required.
> 
> This particular client is on HP and we are using forecedirectio. I had 
> thought that forcedirectio mount option didn't make a difference unless the 
> database was using filesystemio_options=setall or directio, but now I have 
> some doubts and will test tomorrow.
> 
> Best Wishes
> Kyle Hailey
> http://dboptimizer.com
> 
> 
> On Sun, Apr 17, 2011 at 8:18 PM, Chitale, Hemant Krishnarao 
> <Hemant.Chitale@xxxxxx> wrote:
> 
> The note still requires forcedirectio on Solaris and HPUX and cio on AIX even 
> for non-RAC implementations.
> 
> Kyle,
> It's not clear to me if the NFS implementation is on Linux or on a Unix 
> flavour, because you say " The NFS database is using direct-IO so there is no 
> longer the buffering from the UNIX."
> 
> 
> Hemant K Chitale
> 
> -----Original Message-----
> From: D'Hooge Freek [mailto:Freek.DHooge@xxxxxxxxx]
> Sent: Sunday, April 17, 2011 1:46 AM
> To: kylelf@xxxxxxxxx; ORACLE-L
> Subject: RE: NFS and direct IO
> 
> Kyle,
> <deleted>
> 
> Directio is only required on linux when working with rac.
> See note Mount Options for Oracle files when used with NAS devices [ID 
> 359515.1]
> 
> Regards,
> 
> 
> Freek D'Hooge
> Uptime
> Oracle Database Administrator
> email: freek.dhooge@xxxxxxxxx
> tel +32(0)3 451 23 82
> http://www.uptime.be
> disclaimer: www.uptime.be/disclaimer
> ________________________________________
> From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
> Behalf Of kyle Hailey
> Sent: zaterdag 16 april 2011 18:31
> To: ORACLE-L
> Subject: NFS and direct IO
> 
> Is there any requirement to use direct I/O with NFS? (besides performance)
> 
> from metalink note: Enterprise Linux: Linux, Filesystem & I/O Type 
> Supportability [ID 279069.1]
> 
>     DIRECTIO is required for database files on NAS (network attached storage).
> 
> Is it really  required? I can't find any other reference that supports this.
> 
> <deleted>
> 
> This email and any attachments are confidential and may also be privileged.  
> If you are not the addressee, do not disclose, copy, circulate or in any 
> other way use or rely on the information contained in this email or any 
> attachments.  If received in error, notify the sender immediately and delete 
> this email and any attachments from your system.  Emails cannot be guaranteed 
> to be secure or error free as the message and any attachments could be 
> intercepted, corrupted, lost, delayed, incomplete or amended.  Standard 
> Chartered PLC and its subsidiaries do not accept liability for damage caused 
> by this email or any attachments and may monitor email traffic.
> 
> 
> 
> Standard Chartered PLC is incorporated in England with limited liability 
> under company number 966425 and has its registered office at 1 Aldermanbury 
> Square, London, EC2V 7SB.
> 
> 
> 
> Standard Chartered Bank ("SCB") is incorporated in England with limited 
> liability by Royal Charter 1853, under reference ZC18.  The Principal Office 
> of SCB is situated in England at 1 Aldermanbury Square, London EC2V 7SB. In 
> the United Kingdom, SCB is authorised and regulated by the Financial Services 
> Authority under FSA register number 114276.
> 
> 
> 
> If you are receiving this email from SCB outside the UK, please click 
> http://www.standardchartered.com/global/email_disclaimer.html to refer to the 
> information on other jurisdictions.
> 
>

Other related posts: