Re: datawarehouse implementation

Posted by ErmanArslansOracleBlog on Jul 06, 2018; 1:14pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/datawarehouse-implementation-tp6350p6363.html

First, understand the RAID types and then make your decision accordingly.

For ex: Raid mirror is good for write performance.. You may place your redolog files on Raid Mirror based disks, because LGWR is write intensive and it has to be very quick when writing..

As for the Storage tier, ASM is not enough.. The underlying disks and the storage is also important..
For ex: you may put your redologs to ssd disks.. You may consider using Exadata, or a new generation ODA ...

So, for each decision, you should think all the details..