Hello
Here's an execution plan taken from a 12c (12.1.0.2) database.
INSERT /*+ append parallel(bsic,4) */
INTO XYZ_HIST bsic
SELECT /*+ parallel(oltp,4) */ *
FROM XYZ oltp
WHERE DATIS > add_months(sysdate,-24)
--------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes |
--------------------------------------------------------------------------
| 0 | INSERT STATEMENT | | 818M| 112G|
| 1 | PX COORDINATOR | | | |
| 2 | PX SEND QC (RANDOM) | :TQ10000 | 818M| 112G|
| 3 | LOAD AS SELECT (HYBRID TSM/HWMB)| XYZ_HIST | | |
| 4 | OPTIMIZER STATISTICS GATHERING | | 818M| 112G|
| 5 | PX BLOCK ITERATOR | | 818M| 112G|
|* 6 | TABLE ACCESS FULL | XYZ | 818M| 112G|
--------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
6 - filter("DATIS">ADD_MONTHS(SYSDATE@!,-24))
Note
-----
- Degree of Parallelism is 4 because of table property
SQL> select table_name, degree
2 from dba_tables
3 where table_name = 'XYZ';
TABLE_NAME DEGREE
---------- ----------
XYZ 1
The Note is saying that the degree of parallelism is due to a table property while the table is set at a degree of 1. It seems that the degree of parallelism is rather coming from the hint I have used in contrast to what the Note is saying
Best regards
Mohamed Houri