RE: Storage choice for Oracle database on VMware

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_at_comcast.net <mailto:Dimensional.dba_at_comcast.net>

 <http://www.linkedin.com/pub/matthew-parker/6/51b/944/> View Matthew Parker's profile on LinkedIn

www.dimensionaldba.com <http://www.dimensionaldba.com/>    

From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> On Behalf Of Chris Taylor Sent: Tuesday, October 30, 2018 10:30 AM To: cichomitiko_at_gmail.com
Cc: ORACLE-L <oracle-l_at_freelists.org> 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_at_gmail.com <mailto:cichomitiko_at_gmail.com> > 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    

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