RE: Strange behavior of INSERT via DB-link

1. "_at_source.afrsldb1" is the real link (while explaining the story I didn't want to confuse anybody with local names).
2. Tried your statement - no difference, still creates that reverse session.

By the way, just for the sake of experiment did a Cartesian join to DUAL - the reverse session was gone:

insert into misha01 (a,b)
with t_remote as (select/*+ inline no_merge */ substr(b,1,2) c from misha01_at_source.afrsldb1) select misha_seq.nextval,

            c
from t_remote,

          dual ----------------- Cartesian join

From: Sayan Malakshinov [mailto:xt.and.r_at_gmail.com] Sent: Wednesday, August 14, 2013 3:10 PM To: Michael Rosenblum
Cc: oracle-l_at_freelists.org
Subject: Re: Strange behavior of INSERT via DB-link

Hm, i think also that it's very strange. In your trace:

      kkoqbc: optimizing query block INS$1 (#0) And in my:

      kkoqbc: optimizing query block SEL$1 (#0)

Is the "_at_source.afrsldb1" real dblink? Or may be it is the loopback link?

And did you try this:

insert into misha01 (a,b)
with t_remote as (select/*+ inline no_merge */ substr(b,1,2) c from misha01_at_sourceDb.server1<mailto:misha01_at_sourceDb.server1>) select misha_seq.nextval,

            c
from t_remote

On Wed, Aug 14, 2013 at 10:24 PM, Michael Rosenblum <mrosenblum_at_dulcian.com<mailto:mrosenblum_at_dulcian.com>> wrote: Here at Dulcian we took standardization of all environments too seriously - I don't have anything available other than 11.2.0.3, unfortunately :)

10053 trace - see attached. IMHO, trace also looks strange.

Thanks,
Michael

--

Best regards,
Sayan Malakshinov
Senior performance tuning engineer
PSBank
http://orasql.org

--

http://www.freelists.org/webpage/oracle-l Received on Wed Aug 14 2013 - 21:14:53 CEST