Re: How much RAM is to much
Date: Fri, 11 Feb 2011 13:46:55 -0800 (PST)
Message-ID: <495934.96834.qm_at_web83603.mail.sp1.yahoo.com>
Hi Freek,
What you said is true for filesystems that do NOT allow "direct I/O" mount
options in their respective mount commands. But for those filesystems that do
(i.e. vxfs, jfs etc) support the relevant direct I/O mount options, the direct
I/O mount option has always (in my experience) been required in addition to
setting filesystemio_options to SETALL. Setting just the filesystemio_options in
the init.ora (in those cases) did not create the desired result.
If you have observed the "lack of the mount option" in recent times on those filesystems where direct I/O mount options ARE supported (i.e. vxfs, jfs etc), please advise. There is always something to learn new each day :)
Cheers,
Gaja
Gaja Krishna Vaidyanatha,
Founder/Principal, DBPerfMan LLC
http://www.dbperfman.com
Phone - 001-(650)-743-6060
Co-author:Oracle Insights:Tales of the Oak Table -
http://www.apress.com/book/bookDisplay.html?bID=314
Co-author:Oracle Performance Tuning 101 -
http://www.amazon.com/gp/reader/0072131454/ref=sib_dp_pt/102-6130796-4625766
From: D'Hooge Freek <Freek.DHooge_at_uptime.be> To: "ChrisDavid.Taylor_at_ingrambarge.com" <ChrisDavid.Taylor_at_ingrambarge.com>; "andrew.kerber_at_gmail.com" <andrew.kerber_at_gmail.com>; Gaja Krishna Vaidyanatha <gajav_at_yahoo.com>
Cc: "RStorey_at_dcso.nashville.org" <RStorey_at_dcso.nashville.org>; oracle-l-freelists <oracle-l_at_freelists.org> Sent: Thu, February 10, 2011 11:38:43 PM Subject: RE: How much RAM is to much
Hmm, I don't think you need to mount with directio when setting the
filesytemio_options parameter to "directIO" or to "setall".
When using rac with nfs, the oracle required mount options do not include a
setting to force directIO (but on solaris they do).
X-archive-position: 34350
X-ecartis-version: Ecartis v1.0.0
Sender: oracle-l-bounce_at_freelists.org
Errors-to: oracle-l-bounce_at_freelists.org
X-original-sender: Freek.DHooge_at_uptime.be
Precedence: normal
Reply-To: Freek.DHooge_at_uptime.be
List-help: <mailto:ecartis_at_freelists.org?Subject=help> List-unsubscribe: <oracle-l-request_at_freelists.org?Subject=unsubscribe> List-software: Ecartis version 1.0.0 List-Id: oracle-l <oracle-l.freelists.org>X-List-ID: oracle-l <oracle-l.freelists.org>
List-subscribe: <oracle-l-request_at_freelists.org?Subject=subscribe> List-owner: <mailto:steve.adams_at_ixora.com.au> List-post: <mailto:oracle-l_at_freelists.org> List-archive: <http://www.freelists.org/archives/oracle-l>X-list: oracle-l
Mount Options for Oracle files when used with NAS devices [ID 359515.1]
Regards,
Freek D'Hooge
Uptime
Oracle Database Administrator
email: freek.dhooge_at_uptime.be
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer: www.uptime.be/disclaimer
--- From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Taylor, Chris David Sent: donderdag 10 februari 2011 20:58 To: 'andrew.kerber_at_gmail.com'; 'Gaja Krishna Vaidyanatha' Cc: 'RStorey_at_dcso.nashville.org'; 'oracle-l-freelists' Subject: RE: How much RAM is to much Doesn't direct IO have to configured in the mount options for the filesystems?Received on Fri Feb 11 2011 - 15:46:55 CST
(Not just specified in the Oracle parameters)
Otherwise, you're in fact not using it, right? Or do filesystems now-a-days get mounted with direct as an option automatically in Linux? Chris Taylor Sr. Oracle DBA Ingram Barge Company Nashville, TN 37205 Office: 615-517-3355 Cell: 615-663-1673 Email: chris.taylor_at_ingrambarge.com CONFIDENTIALITY NOTICE: This e-mail and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and delete the contents of this message without disclosing the contents to anyone, using them for any purpose, or storing or copying the information on any medium. -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l