Hi Lyall, You could check on these docs http://www.oracle.com/technology/products/bi/db/11g/pdf/twp_dw_best_practies_11g11_2008_09.pdf http://www.oracle.com/technology/products/bi/db/11g/pdf/twp_bidw_parallel_execution_11gr1.pdf And I've also compiled some Datawarehouse metalink notes here http://karlarao.tiddlyspot.com/#DataWarehouseMetalink -- Karl Arao karlarao.wordpress.com karlarao.tiddlyspot.com -- //www.freelists.org/webpage/oracle-l