RE: Is filesystemio_options relevant when the database is on ASM ?
Date: Thu, 16 Oct 2014 15:13:23 +0000
Message-ID: <AF02C941134B1A4AB5F61A726D08DCED0E0E3CDD_at_USA7109MB012.na.xerox.net>
We started using DNFS about two years ago (11gR2). I did raise this question with Oracle through an SR, that is, whether or not the FILESYSTEMIO_OPTIONS parameter needs to be set for DNFS type environments, and I was told that it was not needed as the DNFS code bypasses the filesystemio_options code. However, the Oracle kernel group also suggested that as a general best practice, it should be set to setall as it is not going to impact DNFS type configurations.
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mark W. Farnham
Sent: Thursday, October 16, 2014 11:04 AM
To: frits.hoogland_at_gmail.com; Hemant-K.Chitale_at_sc.com
Cc: 'ORACLE-L'
Subject: RE: Is filesystemio_options relevant when the database is on ASM ?
The immediate side question becomes: Can we catalog any situations in which the 'setall' setting is suboptimal?
IF there are no known situations where 'setall' is harmful, then I believe it would be wise to set it as standard operating procedure. IF there are some known situations where 'setall' is suboptimal, then the catalog of exceptions would be gold. (Setting it when it does no harm operationally being irrelevant beyond a few microseconds at database restart to parse the parameter.)
mwf
From: oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Frits Hoogland
Sent: Thursday, October 16, 2014 5:35 AM
To: Hemant-K.Chitale_at_sc.com<mailto:Hemant-K.Chitale_at_sc.com>
Cc: ORACLE-L
Subject: Re: Is filesystemio_options relevant when the database is on ASM ?
Hi Hermant,
With version 11 ASM (ASM needs to be available on the node where the database lives), and when using Exadata, filesystemio_options is NOT relevant to the database processes when using files (redo, data, temp) on local ASM managed devices. I am not sure with version 12, probably the locality between the device and the ASM instance which it manages is relevant.
When using NFS underneath ASM, I've witnessed filesystemio_options being honoured by the database, which means it needs setting it to 'setall' for the combination AIO+DIO. Which makes sense, because you need to create a file on a (NFS) filesystem to be used as ASM disk device.
Frits Hoogland
http://fritshoogland.wordpress.com<http://fritshoogland.wordpress.com/>
frits.hoogland_at_gmail.com<mailto:frits.hoogland_at_gmail.com>
Office : +31 20 5939953
Mobile: +31 6 14180860
On 16 Oct 2014, at 11:25, Chitale, Hemant K <Hemant-K.Chitale_at_sc.com<mailto:Hemant-K.Chitale_at_sc.com>> wrote:
Is filesystemio_options relevant when the database is on ASM ?
Hemant K Chitale
This email and any attachments are confidential and may also be privileged. If you are not the intended recipient, please delete all copies and notify the sender immediately. You may wish to refer to the incorporation details of Standard Chartered PLC, Standard Chartered Bank and their subsidiaries at https://www.sc.com/en/incorporation-details.html.
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Oct 16 2014 - 17:13:23 CEST