Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Recommended Hardware Config for huge OLAP Cube build

446982Jul 27 2011 — edited Jul 29 2011

Hi David ,

Can you please provide the recommended hardware config for cube having billions of data under fact table . We ran a cube with 0.1 billion of data took around 7 hours to process. What could be the key areas to gain the performance benefit ? ansd also what could be the CPU , RAM (server) , RAM (Oracle DB) to gain much more perf benefit in such configurations ?
Also we have 32 bit windows 2003 server .Can we get better result if we switch to 64 bit ?

Thanks in advance,
DxP.

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 26 2011

Added on Jul 27 2011

#data-warehousing, #olap

3 comments

238 views