INSERT /*+ append parallel(16) nologging */ INTO USER1.TAB (c1, c2, c3, c4... c11) SELECT...; OLD Plan:- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | Pstart| Pstop | TQ |IN-OUT| PQ Distrib | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 0 | INSERT STATEMENT | | | | | 94033 (100)| | | | | | | | 1 | PX COORDINATOR | | | | | | | | | | | | | 2 | PX SEND QC (RANDOM) | :TQ10005 | 31M| 3834M| | 94033 (1)| 00:18:49 | | | Q1,05 | P->S | QC (RAND) | | 3 | INDEX MAINTENANCE | TAB | | | | | | | | Q1,05 | PCWP | | | 4 | PX RECEIVE | | 31M| 3834M| | 94033 (1)| 00:18:49 | | | Q1,05 | PCWP | | | 5 | PX SEND RANGE | :TQ10004 | 31M| 3834M| | 94033 (1)| 00:18:49 | | | Q1,04 | P->P | RANGE | | 6 | LOAD AS SELECT | | | | | | | | | Q1,04 | PCWP | | | 7 | SORT ORDER BY | | 31M| 3834M| 4231M| 94033 (1)| 00:18:49 | | | Q1,04 | PCWP | | | 8 | PX RECEIVE | | 31M| 3834M| | 31710 (1)| 00:06:21 | | | Q1,04 | PCWP | | | 9 | PX SEND PARTITION (KEY) | :TQ10003 | 31M| 3834M| | 31710 (1)| 00:06:21 | | | Q1,03 | P->P | PART (KEY) | | 10 | HASH JOIN BUFFERED | | 31M| 3834M| | 31710 (1)| 00:06:21 | | | Q1,03 | PCWP | | | 11 | PX RECEIVE | | 953K| 10M| | 308 (1)| 00:00:04 | | | Q1,03 | PCWP | | | 12 | PX SEND BROADCAST | :TQ10000 | 953K| 10M| | 308 (1)| 00:00:04 | | | Q1,00 | P->P | BROADCAST | | 13 | PX BLOCK ITERATOR | | 953K| 10M| | 308 (1)| 00:00:04 | KEY | KEY | Q1,00 | PCWC | | | 14 | TABLE ACCESS STORAGE FULL | TAB2 | 953K| 10M| | 308 (1)| 00:00:04 | KEY | KEY | Q1,00 | PCWP | | | 15 | HASH JOIN | | 30M| 3412M| | 31392 (1)| 00:06:17 | | | Q1,03 | PCWP | | | 16 | PX RECEIVE | | 33M| 954M| | 23178 (1)| 00:04:39 | | | Q1,03 | PCWP | | | 17 | PX SEND HASH | :TQ10001 | 33M| 954M| | 23178 (1)| 00:04:39 | | | Q1,01 | P->P | HASH | | 18 | PX BLOCK ITERATOR | | 33M| 954M| | 23178 (1)| 00:04:39 |KEY(I) |KEY(I) | Q1,01 | PCWC | | | 19 | TABLE ACCESS STORAGE FULL| TAB3 | 33M| 954M| | 23178 (1)| 00:04:39 |KEY(I) |KEY(I) | Q1,01 | PCWP | | | 20 | PX RECEIVE | | 30M| 2529M| | 8190 (1)| 00:01:39 | | | Q1,03 | PCWP | | | 21 | PX SEND HASH | :TQ10002 | 30M| 2529M| | 8190 (1)| 00:01:39 | | | Q1,02 | P->P | HASH | | 22 | PX BLOCK ITERATOR | | 30M| 2529M| | 8190 (1)| 00:01:39 |KEY(I) |KEY(I) | Q1,02 | PCWC | | | 23 | TABLE ACCESS STORAGE FULL| TAB4 | 30M| 2529M| | 8190 (1)| 00:01:39 |KEY(I) |KEY(I) | Q1,02 | PCWP | | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------- New Plan:- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | Id | Operation | Name | Rows | Bytes |TempSpc| Cost (%CPU)| Time | Pstart| Pstop | TQ |IN-OUT| PQ Distrib | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ | 0 | INSERT STATEMENT | | | | | 552K(100)| | | | | | | | 1 | PX COORDINATOR | | | | | | | | | | | | | 2 | PX SEND QC (RANDOM) | :TQ10006 | 165M| 19G| | 552K (1)| 01:50:36 | | | Q1,06 | P->S | QC (RAND) | | 3 | INDEX MAINTENANCE | TAB | | | | | | | | Q1,06 | PCWP | | | 4 | PX RECEIVE | | 165M| 19G| | 552K (1)| 01:50:36 | | | Q1,06 | PCWP | | | 5 | PX SEND RANGE | :TQ10005 | 165M| 19G| | 552K (1)| 01:50:36 | | | Q1,05 | P->P | RANGE | | 6 | LOAD AS SELECT | | | | | | | | | Q1,05 | PCWP | | | 7 | SORT ORDER BY | | 165M| 19G| 22G| 552K (1)| 01:50:36 | | | Q1,05 | PCWP | | | 8 | PX RECEIVE | | 165M| 19G| | 244K (1)| 00:48:53 | | | Q1,05 | PCWP | | | 9 | PX SEND PARTITION (KEY) | :TQ10004 | 165M| 19G| | 244K (1)| 00:48:53 | | | Q1,04 | P->P | PART (KEY) | | 10 | HASH JOIN BUFFERED | | 165M| 19G| | 244K (1)| 00:48:53 | | | Q1,04 | PCWP | | | 11 | PX RECEIVE | | 4061K| 46M| | 1141 (1)| 00:00:14 | | | Q1,04 | PCWP | | | 12 | PX SEND HASH | :TQ10002 | 4061K| 46M| | 1141 (1)| 00:00:14 | | | Q1,02 | P->P | HASH | | 13 | PX BLOCK ITERATOR | | 4061K| 46M| | 1141 (1)| 00:00:14 | KEY | KEY | Q1,02 | PCWC | | | 14 | TABLE ACCESS STORAGE FULL | TAB2 | 4061K| 46M| | 1141 (1)| 00:00:14 | KEY | KEY | Q1,02 | PCWP | | | 15 | PX RECEIVE | | 164M| 17G| | 243K (1)| 00:48:39 | | | Q1,04 | PCWP | | | 16 | PX SEND HASH | :TQ10003 | 164M| 17G| | 243K (1)| 00:48:39 | | | Q1,03 | P->P | HASH | | 17 | HASH JOIN BUFFERED | | 164M| 17G| 352M| 243K (1)| 00:48:39 | | | Q1,03 | PCWP | | | 18 | PX RECEIVE | | 140M| 4027M| | 102K (1)| 00:20:26 | | | Q1,03 | PCWP | | | 19 | PX SEND HASH | :TQ10000 | 140M| 4027M| | 102K (1)| 00:20:26 | | | Q1,00 | P->P | HASH | | 20 | PX BLOCK ITERATOR | | 140M| 4027M| | 102K (1)| 00:20:26 |KEY(I) |KEY(I) | Q1,00 | PCWC | | | 21 | TABLE ACCESS STORAGE FULL| TAB3 | 140M| 4027M| | 102K (1)| 00:20:26 |KEY(I) |KEY(I) | Q1,00 | PCWP | | | 22 | PX RECEIVE | | 223M| 18G| | 58136 (1)| 00:11:38 | | | Q1,03 | PCWP | | | 23 | PX SEND HASH | :TQ10001 | 223M| 18G| | 58136 (1)| 00:11:38 | | | Q1,01 | P->P | HASH | | 24 | PX BLOCK ITERATOR | | 223M| 18G| | 58136 (1)| 00:11:38 |KEY(I) |KEY(I) | Q1,01 | PCWC | | | 25 | TABLE ACCESS STORAGE FULL| TAB4 | 223M| 18G| | 58136 (1)| 00:11:38 |KEY(I) |KEY(I) | Q1,01 | PCWP | | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------