RE: Is filesystemio_options relevant when the database is on ASM ?
Date: Thu, 16 Oct 2014 17:33:54 +0800
Message-ID: <0BDF2A25A09ADD40908745EEFC0A0FB60279ABDC_at_HKJUMXMB103B.zone1.scb.net>
Thanks. That confirms what I suspected.
Hemant K Chitale
-----Original Message-----
From: Stefan Koehler [mailto:contact_at_soocs.de]
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_at_sc.com> 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. †Ûiÿü0ÁúÞzX¬¶Ê+ƒü n– {ú+iÉ^ Received on Thu Oct 16 2014 - 11:33:54 CEST