Tips for Optimizing Oracle Warehouse Builder 11.1 with Oracle DB 10.2
Make sure that open_cursors is sufficient. What is the current value for open_cursors and session_cached_cursors? They should be high, start with 500.