Re: Strange behavior of INSERT via DB-link
- From: Sayan Malakshinov <xt.and.r@xxxxxxxxx>
- To: Michael Rosenblum <mrosenblum@xxxxxxxxxxx>
- Date: Wed, 14 Aug 2013 23:10:07 +0400
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 "@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@sourceDb.server1)
select misha_seq.nextval,
c
from t_remote
On Wed, Aug 14, 2013 at 10:24 PM, Michael Rosenblum
<mrosenblum@xxxxxxxxxxx>wrote:
> Here at Dulcian we took standardization of all environments too seriously
> I dont 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
