Current System Info:
HP 11 server = 2 CPUS, 4 gigs of memory
datawarehouse = 80 gigs
Largest tables (partitionned) = 10 gigs
Potential data growth over the next 3 years = 400 gigs
Hi, I'm in the market for a new data warehouse server and I'd like to know other's recommendation.
We use HP and Oracle 10g. I'd like to take advantage of oracle parallel processing.
Currently our 2 CPU server takes 20 hours to complete one of our ETL batch run. This has become unacceptable to the client.
***(YES our instance is tuned correctly)***
We our now experiencing a bottleneck with I/O. Memory is fine. Indexes are being used but the data
load is now so massive that our inserts take too long. SGA is running at optimal.
**PLEASE PLEASE don't tell me I need to review my code, indexing, analyze plan**
Everything is tuned. It is the server that is the bottleneck.
How many CPUs should I go with?
How many disk controllers?
I'd just like others input using real world experience. I'd like to lower ourt batch window to less than an house (each week we load approx. 1.5 gigs worth of new data).