Bulk Insert ,  parallel execution with pipe..

two-fold: first, the performance benefits of a bulk SQL INSERT statement; second the potentially massive performance gains of parallel SQL and DML.

"With the former in serial mode I have achieved up to 30% gain in performance, but with the latter I have achieved up to 80% reduction in load time."

http://www.oracle-developer.net/display.php?id=207