Hi Patrick,
Simple rule of thumb for Oracle on Solaris....
Summ up all the source data you plan to put into the DW. This is usually prett easy to fogure out. Call it X.
If you plan to use raid 5 the disk you need as a MINIMUM is 4X.
If you plan to use mirroring the disk you need as a MINIMUM is 8X.
Of course, more disk is always better....
A lot of people tell me 'this can't be true'.
It is.
The way I first came across this number in 1996 was in a review of over 50 sites using Oracle and these were the numbers...they have been very close on every other project I've seen using Oracle.
One of my large clients refused to believe this was true of their Oracle DW.
We did the numbers. The answer was 1:7.96. Data to disk.
Of course, I apologised for being out by 0.04 on this rule of thumb..;-)
Best Regards
Peter Nolan
Data Warehousing Consultant
Mobile: +353 879 581 732
Homepage:
-----Original Message-----
From: owner-dwlist@datawarehousing.com
[
Sent: 12 August 2004 13:04
To: dwlist@datawarehousing.com
Subject: dwlist: Oracle Capacity Planning
Please visit our sponsor today at
For help with list commands, send a message to <
From: patrick1@cytanet.com.cy
Hi all,
does anyone have any rules of thumb for Oracle DW capacity planning? We have estimated our combined tables & index size at 3 Tbyte, including the required history data ...
what other factors should we consider for sizing the amount of storage we need to purchase ?
thanks in advance
Patrick