Re: Storage choice for Oracle database on VMware

From: Stefan Koehler <contact_at_soocs.de>
Date: Tue, 30 Oct 2018 21:20:58 +0100 (CET)
Message-ID: <2116835562.4240.1540930859128_at_ox.hosteurope.de>


Hello Dimitre,
what is the problem with direct I/O? You should never run an Oracle database through page cache anyway :)

I would go with tweaked XFS (e.g. "nobarrier" as this information is usually not passed through correctly with VMDKs on VMFS, etc.) if it is just one single instance in this VM.

Best Regards
Stefan Koehler

Independent Oracle performance consultant and researcher Website: http://www.soocs.de
Twitter: _at_OracleSK

> "Radoulov, Dimitre" <cichomitiko_at_gmail.com> hat am 30. Oktober 2018 um 19:12 geschrieben:
>
> Thank you Chris, Matthew and Niall, 
>  
> so the question is if performancewise ASM is worth it. 
>  
> With the default Oracle database settings the I/O on XFS would be synchronous, right? 
>  
> And if I understand correctly Note 1987437.1, on Linux you cannot enable async I/O without turning on direct I/O too.
>  
> Regards 
> Dimitre

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Oct 30 2018 - 21:20:58 CET

Original text of this message