Tom,
what does this "HYBRID TSM/HWMB" in the below plan indicates? I see this in 12.1.0.2
rajesh@PDB1> explain plan for
2 insert /*+ enable_parallel_dml parallel(t1) */ into t1
3 select /*+ parallel(t) */ * from t ;
Explained.
rajesh@PDB1>
rajesh@PDB1> select * from table(dbms_xplan.display) ;
PLAN_TABLE_OUTPUT
----------------------------------------------------------------------------------------------
Plan hash value: 550883001
--------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | TQ |IN-OUT| PQ Distrib |
--------------------------------------------------------------------------------------------
| 0 | INSERT STATEMENT | | 39 | | | |
| 1 | PX COORDINATOR | | | | | |
| 2 | PX SEND QC (RANDOM) | :TQ10000 | 39 | Q1,00 | P->S | QC (RAND) |
| 3 | LOAD AS SELECT (HYBRID TSM/HWMB)| T1 | | Q1,00 | PCWP | |
| 4 | OPTIMIZER STATISTICS GATHERING | | 39 | Q1,00 | PCWP | |
| 5 | PX BLOCK ITERATOR | | 39 | Q1,00 | PCWC | |
| 6 | TABLE ACCESS FULL | T | 39 | Q1,00 | PCWP | |
--------------------------------------------------------------------------------------------
Note
-----
- Degree of Parallelism is 8 because of table property
17 rows selected.
rajesh@PDB1>