Hello;
We want to create single instance databases Oracle EE 11.2.0.4 and Oracle EE 12.2.0.1 on a virtual machine Oracle Linux 7.6.0.0 x86_64 bits, off course we want the best performance in i/o disk.
The XFS will be created on SAN Full Flash.
I want to split the database files on seven XFS like that:
/oracle/oradata/<SID> <= data
/oracle/oraindx/<SID> <= indexes
/oracle/oradata/<SID>/redo01 <= redo group 1
/oracle/oradata/<SID>/redo02 <= redo group 2
/oracle/oradata/<SID>/ctrl01 <= controlfile 1
/oracle/oradata/<SID>/ctrl02 <= controlfile 2
/sv<SID>/archivelogs <= archive log
Is this XFS architecture well define ?
What are the good mount options, block sizes for each of theses XFS ? Is there a whitepaper about it ? Is the SAN disk blocksize important ?
Is there Oracle Linux 7 x86_64 systems configuration to improve i/o disk ? Is there a whitepaper about it ?
Thanks for your help and feedback.
Regards
ADD