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

Parallel Enabled Pipelined PL/SQL Functions

Parallel Enabled Pipelined PL/SQL Functions very nice..

This shows using Pipe with Parallel feature in it to improve performance.

http://oraganism.wordpress.com/2010/05/18/parallel-enabled-pipelined-plsql-functions-an-old-feature-thats-new-to-me/?blogsub=confirming#subscribe-blog