Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Distributed transaction parallelization in docs
> INSERT /* APPEND PARALLEL (t3,2) */ INTO t3 SELECT * FROM t4_at_dblink;
>
> ..it will be serialized, *because the query is done on remote object*.
Hm, I think I just figured it out, not everything is serialized, only the query part. The local query is serial, the local DML still remains parallel and how the remote query is executed, depends on remote instance's settings..
Tanel. Received on Mon Apr 14 2003 - 12:06:00 CDT
![]() |
![]() |