| PLAN_TABLE_OUTPUT |
|---|
SQL_ID 0ktdd66391zgt, child number 0 | ------------------------------------- | insert /*+ enable_parallel_dml parallel(2) */ into p( x ) select 1 from | dual | | Plan hash value: 232068378 | | ----------------------------------------------------------------------------------------------------------------------- | | Id | Operation | Name | Rows | Cost (%CPU)| Time | TQ |IN-OUT| PQ Distrib | | ----------------------------------------------------------------------------------------------------------------------- | | 0 | INSERT STATEMENT | | | 2 (100)| | | | | | | 1 | PX COORDINATOR | | | | | | | | | | 2 | PX SEND QC (RANDOM) | :TQ10002 | 1 | 2 (0)| 00:00:01 | Q1,02 | P->S | QC (RAND) | | | 3 | INDEX MAINTENANCE | P | | | | Q1,02 | PCWP | | | | 4 | PX RECEIVE | | 1 | 2 (0)| 00:00:01 | Q1,02 | PCWP | | | | 5 | PX SEND RANGE | :TQ10001 | 1 | 2 (0)| 00:00:01 | Q1,01 | P->P | RANGE | | | 6 | LOAD AS SELECT (HYBRID TSM/HWMB)| P | | | | Q1,01 | PCWP | | | | 7 | OPTIMIZER STATISTICS GATHERING | | 1 | 2 (0)| 00:00:01 | Q1,01 | PCWP | | | | 8 | PX RECEIVE | | 1 | 2 (0)| 00:00:01 | Q1,01 | PCWP | | | | 9 | PX SEND ROUND-ROBIN | :TQ10000 | 1 | 2 (0)| 00:00:01 | Q1,00 | S->P | RND-ROBIN | | | 10 | PX SELECTOR | | | | | Q1,00 | SCWC | | | | 11 | FAST DUAL | | 1 | 2 (0)| 00:00:01 | Q1,00 | SCWP | | | ----------------------------------------------------------------------------------------------------------------------- | | Hint Report (identified by operation id / Query Block Name / Object Alias): | Total hints for statement: 1 | --------------------------------------------------------------------------- | | 0 - STATEMENT | - parallel(2) | | Note | ----- | - Degree of Parallelism is 2 because of hint | |