Re: Inserts over dblink

Steve,

Below article from Jonathan Lewis would help

https://jonathanlewis.wordpress.com/2008/12/05/distributed-dml/

Regards
Vijay Sehgal

> On Jun 18, 2017, at 8:10 PM, Steve T. Baldwin <stbaldwin_at_multiservice.com> wrote:
>
> Hi,
>
>
> I've not used DB Links much so this may be a naive question but can someone help me understand why:
>
>
> insert into remote_table_at_dblink select from local_table (approx 30 seconds for 1000 rows)
>
>
> would be ~ 100x slower than:
>
>
> insert into local_table select from remote_table_at_dblink (approx 0.3 seconds for 1000 rows)
>
>
> Thanks,
>
>
> Steve
>
>
> ------------------------------------------------------------------
> This email is intended solely for the use of the
> addressee and may contain information that is
> confidential, proprietary, or both. If you receive
> this email in error please immediately notify
> the sender and delete the email.
> ------------------------------------------------------------------

--
http://www.freelists.org/webpage/oracle-l