insert /*+ parallel (6) */ into Tabparallel1 select /*+ parallel (6) */ * from Tabparallel
Plan
INSERT STATEMENT ALL_ROWSCost: 73
5 LOAD TABLE CONVENTIONAL RICK.TABPARALLEL1
4 PX COORDINATOR
3 PX SEND QC (RANDOM) PARALLEL_TO_SERIAL SYS.:TQ10000 :Q1000Cost: 73 Bytes: 9,641,280 Cardinality: 73,040
2 PX BLOCK ITERATOR PARALLEL_COMBINED_WITH_CHILD :Q1000Cost: 73 Bytes: 9,641,280 Cardinality: 73,040
1 TABLE ACCESS FULL TABLE PARALLEL_COMBINED_WITH_PARENT RICK.TABPARALLEL :Q1000Cost: 73 Bytes: 9,641,280 Cardinality: 73,040
alter session enable parallel dml; DML 并行
Plan
INSERT STATEMENT ALL_ROWSCost: 73
6 PX COORDINATOR
5 PX SEND QC (RANDOM) PARALLEL_TO_SERIAL SYS.:TQ10000 :Q1000Cost: 73 Bytes: 9,641,280 Cardinality: 73,040
4 LOAD AS SELECT (HYBRID TSM/HWMB) PARALLEL_COMBINED_WITH_PARENT RICK.TABPARALLEL1 :Q1000
3 OPTIMIZER STATISTICS GATHERING PARALLEL_COMBINED_WITH_PARENT :Q1000Cost: 73 Bytes: 9,641,280 Cardinality: 73,040
2 PX BLOCK ITERATOR PARALLEL_COMBINED_WITH_CHILD :Q1000Cost: 73 Bytes: 9,641,280 Cardinality: 73,040
1 TABLE ACCESS FULL TABLE PARALLEL_COMBINED_WITH_PARENT RICK.TABPARALLEL :Q1000Cost: 73 Bytes: 9,641,280 Cardinality: 73,040
Plan
UPDATE STATEMENT ALL_ROWSCost: 561
5 PX COORDINATOR
4 PX SEND QC (RANDOM) PARALLEL_TO_SERIAL SYS.:TQ10000 :Q1000Cost: 561 Bytes: 225,012,320 Cardinality: 2,163,580
3 UPDATE PARALLEL_COMBINED_WITH_PARENT RICK.TMP_T0 :Q1000
2 PX BLOCK ITERATOR PARALLEL_COMBINED_WITH_CHILD :Q1000Cost: 561 Bytes: 225,012,320 Cardinality: 2,163,580
1 TABLE ACCESS FULL TABLE PARALLEL_COMBINED_WITH_PARENT RICK.TMP_T0 :Q1000Cost: 561 Bytes: 225,012,320 Cardinality: 2,163,580