Re: Storage choice for Oracle database on VMware

Why are you not fond of XFS and/or LVM? What would be the great advantage of ASM? You have 2 GB RAM too much? I am trying to avoid ASM whenever I can. And so is Oracle. New ODA and Exadata boxes come with Oracle data files on ACFS file system. Personally, I think that ASM is a pain in the neck or lower and shouldn't be used unless the database is RAC.

Regards

On 10/30/18 5:38 PM, Andrew Kerber wrote:
> Most places with growing databases and heavy duty environments on
> vmware use ASM.  Some use XFS or similar and LVM, though I am not fond
> of those.
>
> On Tue, Oct 30, 2018 at 4:34 PM Leng <lkaing_at_gmail.com
> <mailto:lkaing_at_gmail.com>> wrote:
>
> Asm is great when you plan correctly. If you don’t it’s very
> painful. Eg. If you have different sized disks asm will be forever
> rebalancing, and failing as there is not enough space on the odd
> disk. So you need to vacate the diskgroup to rebuild it. (Yes, you
> know... not my fault, the previous consultant did it...) If
> there’s an asm bug you may have to take an outage on the Asm to
> apply the patch.
>
> Normal disk operations like dd to asm is almost impossible. Trying
> to find that corrupted data block on the asm disk takes great asm
> expertise from a great oracle support engineer.
>
> Those were some up of my worst asm nightmares. It was only 2 years
> ago. I have since moved on...
>
> Cheers,
> Leng
>
> > On 31 Oct 2018, at 7:20 am, Stefan Koehler <contact_at_soocs.de
> <mailto:contact_at_soocs.de>> wrote:
> >
> > 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
> <mailto: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
> >
> >
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
>
> --
> Andrew W. Kerber
>
> 'If at first you dont succeed, dont take up skydiving.'

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217


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