12-28-2018
1,484,
567
Join Date: Mar 2011
Last Activity: 28 November 2020, 9:34 AM EST
Posts: 1,484
Thanks Given: 68
Thanked 567 Times in 444 Posts
On VMWARE i would recommend using RDM, multiples of, in SAN environments.
Inside the guest, use ASM and minimize filesystem caching via kernel parameters, since you will not need it.
If filesystems are used, go XFS and limit the filesystem caching considering the size of SGA / PGA from Oracle side.
Check out the tuning docs regarding from Oracle side.
In either case, using ASM or XFS with volume manager, be sure to separate REDO, DATA and archive logs do use different RDMs.
On storage side, set new page assignment on REDO LUN to hit the fastest you have.
DATA then comes second disk performance wise, while archive logs can be slowest rust.
Use storage to provide snapshots, cloning and stuff.
One monster lun then datastore then guest database sure sounds like a nightmare from my perspective.
Hope that helps
Regards
Peasant.