Re: Strange behavior of INSERT via DB-link
Date: Wed, 14 Aug 2013 23:10:07 +0400
Message-ID: <CAOVevU6xKGDexd9kSz2w6hD5Lbg_HqBZ6CWLi3hRxo4O2X_YQA_at_mail.gmail.com>
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)
select misha_seq.nextval,
c
from t_remote
On Wed, Aug 14, 2013 at 10:24 PM, Michael Rosenblum <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 J****
>
> ** **
>
> 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-lReceived on Wed Aug 14 2013 - 21:10:07 CEST