倾情大奉献--ORACLE+UNIX易错问题集锦

bangqiuxiong · 发表于 2010-4-16 10:44

先下，慢慢看！

asmboy001 · 发表于 2010-4-16 10:55

环境10.2.0.3.0 - 64bit
第一个实验俺在不设置alter session enable parallel dml;
DML照样有并行

SQL_ID  ggqkxt0u73tkt, child number 3
-------------------------------------
insert /*+parallel(a,3)*/ into ljb_parallel a select * from

PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
ljb_parallel2

Plan hash value: 2417911527

-------------------------------------------------------
| Id  | Operation          | Name       | E-Rows |
-------------------------------------------------------
| 1 |  PX COORDINATOR    |             |       |
| 2 | PX SEND QC (RANDOM)| :TQ10000    |  36056 |
| 3 | PX BLOCK ITERATOR |             |  36056 |
|*  4 |    TABLE ACCESS FULL| LJB_PARALLEL2 |  36056 |

[ 本帖最后由 asmboy001 于 2010-4-16 10:56 编辑 ]