Re: Is filesystemio_options relevant when the database is on ASM ?

From: Stefan Koehler <contact_at_soocs.de>
Date: Thu, 16 Oct 2014 11:32:51 +0200 (CEST)
Message-ID: <435589048.68627.1413451971257.open-xchange_at_app04.ox.hosteurope.de>

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

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Oct 16 2014 - 11:32:51 CEST

This message: [ Message body ]
Next message: Chitale, Hemant K: "RE: Is filesystemio_options relevant when the database is on ASM ?"
Previous message: Kenny Payton: "Re: Migrate databases to new servers and storage"
In reply to: Chitale, Hemant K: "Is filesystemio_options relevant when the database is on ASM ?"
Next in thread: Chitale, Hemant K: "RE: Is filesystemio_options relevant when the database is on ASM ?"
Reply: Chitale, Hemant K: "RE: Is filesystemio_options relevant when the database is on ASM ?"
Reply: Chitale, Hemant K: "RE: Is filesystemio_options relevant when the database is on ASM ?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message