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
Il mar 30 ott 2018, 19:06 <niall.litchfield@xxxxxxxxx> ha scritto:
ASM also requires 8GB ram in 18. In a vm environment that's a pretty big
overhead. Not a reason not to do it, but a consideration. You'll also want
to think about what your admins are used to and what vmware refer to as day
2 operations. Disk add, FS expansion, backup etc. There are some specifics
for vmware for databases that you may find your vm admins don't immediately
buy into.
On Tue, 30 Oct 2018, 17:38 Matthew Parker, <dimensional.dba@xxxxxxxxxxx>
wrote:
It is always a choice.
If you decide to use filesystems then XFS, although for some reasons
based on your storage team you may only have NFS available.
ASM still holds a performance advantage over XFS, but not by much.
Extra GRID Infrastructure SW with patching for ASM versus simple XFS file
systems.
*Matthew Parker*
*Chief Technologist*
*Dimensional DBA*
*Oracle Gold Partner*
*425-891-7934 (cell)*
*D&B *047931344
*CAGE *7J5S7
*Dimensional.dba@xxxxxxxxxxx <Dimensional.dba@xxxxxxxxxxx>*
*View Matthew Parker's profile on LinkedIn*
<http://www.linkedin.com/pub/matthew-parker/6/51b/944/>
www.dimensionaldba.com
*From:* oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> *On
Behalf Of *Chris Taylor
*Sent:* Tuesday, October 30, 2018 10:30 AM
*To:* cichomitiko@xxxxxxxxx
*Cc:* ORACLE-L <oracle-l@xxxxxxxxxxxxx>
*Subject:* Re: Storage choice for Oracle database on VMware
After dealing with multiple filesystems of very busy databases for the
last year (one of which is 70+TB), I would say ASM ALL THE WAY. Never go
back to filesystems after using ASM.
Adding space, managing space is so much better on ASM.
Just my $0.02.
Chris
On Tue, Oct 30, 2018 at 12:15 PM Radoulov, Dimitre <cichomitiko@xxxxxxxxx>
wrote:
Hi all,
considering the technology today: XFS as default FS on Linux 7, the
modern HW and the latest VMware versions, what storage type would you use
for a single database instance on VMware?
Oracle versions are from 11.2 to 12.2, database size varies from 300G to
3T+.
Would you use XFS with non-default values for filesystemio_options or
ASM?
Regards
Dimitre
