Re: Is filesystemio_options relevant when the database is on ASM ?
- From: Stefan Koehler <contact@xxxxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>, Hemant-K.Chitale@xxxxxx
- Date: Thu, 16 Oct 2014 11:32:51 +0200 (CEST)
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
