INSERT INTO TT_TBL (...) SELECT TT.* FROM ANOTHER_TEMP_TBL TT LEFT JOIN T1 ON TT.FK = T1.PK LEFT JOIN T2 ON T1.FK = T2.PK WHERE ... call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 695 1.57 1.63 0 65600 528 635 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 696 1.57 1.63 0 65600 528 635 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 61 (recursive depth: 1) Rows Row Source Operation ------- --------------------------------------------------- 635 HASH JOIN (cr=65597 pr=0 pw=0 time=1361047 us) 628 NESTED LOOPS (cr=17241 pr=0 pw=0 time=300294 us) 628 TABLE ACCESS FULL T1 (cr=15985 pr=0 pw=0 time=144925 us) 628 TABLE ACCESS BY INDEX ROWID T2 (cr=1256 pr=0 pw=0 time=86924 us) 628 INDEX UNIQUE SCAN PK_T2 (cr=628 pr=0 pw=0 time=35798 us)(object id 70300) 398780 TABLE ACCESS FULL TT (cr=48356 pr=0 pw=0 time=7659565 us) ***************************************************************************************************** INSERT INTO TT_TBL (...) SELECT /*+ PARALLEL(T1, 2) PARALLEL(T2, 2) */ TT.* FROM ANOTHER_TEMP_TBL TT LEFT JOIN T1 ON TT.FK = T1.PK LEFT JOIN T2 ON T1.FK = T2.PK WHERE ... call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 6 0.15 6.67 0 515 14 4 Fetch 0 0.00 0.00 0 0 0 0 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 7 0.15 6.67 0 515 14 4 Misses in library cache during parse: 1 Misses in library cache during execute: 1 Optimizer mode: ALL_ROWS Parsing user id: 61 (recursive depth: 1) Elapsed times include waiting on following events: Event waited on Times Max. Wait Total Waited ---------------------------------------- Waited ---------- ------------ PX Deq: Join ACK 18 0.00 0.01 PX qref latch 884 0.00 0.04 PX Deq Credit: send blkd 27 1.97 5.87 PX Deq: Parse Reply 20 0.01 0.02 PX Deq: Execute Reply 171 0.00 0.01 PX Deq: Table Q Normal 10 0.00 0.00 PX Deq: Signal ACK 22 0.10 0.49 enq: PS - contention 7 0.03 0.04 PX Deq Credit: need buffer 3 0.00 0.00 *****************************************************************************************************