dml下需要alter session enable parallel dml,再是并行delete效果咋样了,不过并行确实是存在的,但是一般insert用得多点。
SQL> alter session enable parallel dml;
Session altered
SQL> explain plan for delete /*+parallel(a,2)*/ from test04 a;
Explained
SQL> select * from table(dbms_xplan.display());
PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
Plan hash value: 2190704079
--------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time
--------------------------------------------------------------------------------
| 0 | DELETE STATEMENT | | 35 | 2905 | 2 (0)| 00:00
| 1 | PX COORDINATOR | | | | |
| 2 | PX SEND QC (RANDOM) | :TQ10001 | 35 | 2905 | 2 (0)| 00:00
| 3 | INDEX MAINTENANCE | TEST04 | | | |
| 4 | PX RECEIVE | | 35 | 2905 | 2 (0)| 00:00
| 5 | PX SEND RANGE | :TQ10000 | 35 | 2905 | 2 (0)| 00:00
| 6 | DELETE | TEST04 | | | |
| 7 | PX BLOCK ITERATOR | | 35 | 2905 | 2 (0)| 00:00
| 8 | TABLE ACCESS FULL| TEST04 | 35 | 2905 | 2 (0)| 00:00
--------------------------------------------------------------------------------
Note
-----
- 'PLAN_TABLE' is old version