I attended an excellent presentation give by Maria Colgan, Sr. Product Manager at Oracle. The title was ‘Best Practices for a Data Warehouse on Oracle’.
Great tuning tips encompassing the entire architecture of a DW — hardware, network, storage, and of course, Oracle DB.
A whitepaper version of the presentation may be found on the OTN website:
http://www.oracle.com/technology/products/bi/db/11g/pdf/twp_dw_best_practies_11g11_2008_09.pdf
I highly recommend.
Tweet If you enjoyed this post, make sure you subscribe to my RSS feed!