还和磁盘i / o有关系。
-----------------------------------------------------------------
Parallel Direct-Path INSERT into a Nonpartitioned Table
Each parallel execution server allocates a new temporary segment and inserts data into that temporary segment. When a COMMIT executes, the parallel execution coordinator merges the new temporary segments into the primary table segment, where it is visible to users.
to space6212
insert /*+paralllel(a,2)*/ into table1 a select * from table2;
和
insert /*+ append paralllel(a,2) */ into table1 a select * from table2;
是一样的吧,因为parallel包含了append
原帖由 chenzhanyiasd 于 2008-7-26 19:28 发表
to space6212
insert /*+paralllel(a,2)*/ into table1 a select * from table2;
和
insert /*+ append paralllel(a,2) */ into table1 a select * from table2;
是一样的吧,因为parallel包含了append
append 和parallael连用,会影响PARALLEL的
参考这个
http://dba.ipbhost.com/index.php?&showtopic=2541
using the APPEND hint may cause serialization,
removing the benefit of parallel jobstreams
[ 本帖最后由 wangfans 于 2008-7-26 22:53 编辑 ]