Re: XFS vs Ext4 redux -- preferences/warnings/etc

Hello Rich,
one clear recommendation: Go with XFS.

XFS has several performance advantages and scales much better. I have done a lot of performance benchmarks and the result was almost every time the same in different client environments. However you can benchmark it on your own with SLOB very easily.

P.S.: Here is a PDF (https://users.soe.ucsc.edu/~sbrandt/290S/xfs.pdf) which explains one of the performance advantages (e.g. on page 10 - Using Multiple Processes) as you should use directIO anyway.

Best Regards
Stefan Koehler

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

> Rich J <rjoralist3_at_society.servebeer.com> hat am 10. April 2019 um 20:54 geschrieben:
>
> Hey all,
>
> I'm planning an install/migration of 12.2 on OEL7, no ASM.  So, should I use XFS or Ext4?  Underlying storage will be flash-based traditional SAN.
>
> MOS 236826.1 says to use "any filesystem that is supported by the Linux vendor".  MOS 1632127.1 says "Beginning with Oracle Linux 7, XFS is the default file system and is included with Basic and Premier Support subscriptions, at no additional charge."
>
> I've had my OEM 13c server using XFS for 18 months without a hiccup, but the repo DB is about 30x smaller than our ERP DB, with way fewer transactions, etc.
>
> Anyone have any experiences with XFS or Ext4 on OEL7 that would make them choose one over the other?
>
> Thanks,
> Rich

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