Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Distributed transaction parallelization in docs

Re: Distributed transaction parallelization in docs

From: Tanel Poder <tanel_at_@peldik.com>
Date: Mon, 14 Apr 2003 20:06:00 +0300
Message-ID: <3e9ae9ac$1_2@news.estpak.ee>


> 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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US