RE: Is filesystemio_options relevant when the database is on ASM ?
- From: "Chitale, Hemant K" <Hemant-K.Chitale@xxxxxx>
- To: "Stefan Koehler" <contact@xxxxxxxx>
- Date: Thu, 16 Oct 2014 17:33:54 +0800
Thanks. That confirms what I suspected.
Hemant K Chitale
-----Original Message-----
From: Stefan Koehler [mailto:contact@xxxxxxxx]
Sent: Thursday, October 16, 2014 5:33 PM
To: ORACLE-L; Chitale, Hemant K
Subject: Re: Is filesystemio_options relevant when the database is on ASM ?
Hi Hemant,
no, it is not in case of ASM.
"RDBMS does raw IO against the ASM disks, so need for FILESYSTEMIO_OPTIONS
parameter. The only parameter that needs to be set is disk_asyncio=true, which
is true by default. If using ASMLIB then even the disk_async does not need to
be set."
Check slide 11 of the Oracle presentation "Top 10 Things You Always Wanted to
Know About Automatic Storage Management But Were Afraid to Ask" for more
detailed information.
http://www.dbaexpert.com/blog/wp-content/uploads/2009/08/doug-top-10-asm-questions.pdf
Best Regards
Stefan Koehler
Oracle performance consultant and researcher http://www.soocs.de
> "Chitale, Hemant K" <Hemant-K.Chitale@xxxxxx> hat am 16. Oktober 2014 um
> 11:25 geschrieben:
>
> 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.
Other related posts:
