AW: AW: Slow performance of code using dblinks ver 8.1.6.2

Hi!

Sorry, just a few questions more instead of an answer. Do you have the same NLS settings on both instances? Are there joins between local tables and/or remote tables in your select statement?

What does the result set ( how many rows, columns ) of your select look like?

regards A.H.

> ----------
> Von: Mohammad Rafiq[SMTP:rafiq9857_at_hotmail.com]
> Gesendet: Freitag, 23. Februar 2001 22:00
> An: Multiple recipients of list ORACLE-L
> Betreff: Re: AW: Slow performance of code using dblinks ver 8.1.6.2
>
> Thanks for your only response from the list. Same code is running in 15
> minutes using db_links between 7.3.4.5 databases but very very slow when
> running from 8.1.6.2 to 7.3.4.5 database. This is basicaly an Ananymouse
> PL/SQL block which select rows from 7.3.4.5 database and insert into a
> table
> 8.1.6.2 database...If you or any list guru has any idea ,please
> help/comment.
> Have a nice weekend...
> Regards
> Rafiq
>
>
> Reply-To: ORACLE-L_at_fatcity.com
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Date: Thu, 22 Feb 2001 10:31:46 -0800
>
> Hi!
>
> Got similar problems concerning database links,
> mainly slow performance, about 10% of the throughput compared to same
> processing without db_links.
> There seems to be no - or at least only poor - useful documentation for
> database links and/or
> about tuning their performance.
>
> Would be a nice new thread for ORACLE-L : "Database Links: Tuning /
> Problems
> / Tips & Traps ..."
>
> The only thing that helped ( in our case) , was to rewrite the code, in
> order to "partition"
> the old big program ( which did all ) into a bunch of small programs (
> each
> doing now only a few things).
> Also consider rewriting your programs in such a way, that you can have
> multiple
> instances of them running simultaneously.
> You know, "divide et impera".
>
> But I'm sure, there must be a secret switch somewhere deep in Oracle's
> guts,
> Iabelled "Boost DB_LINK Performance". I just haven't found it yet ;-)
>
> A.H.
>
>
> > ----------
> > Von: Mohammad Rafiq[SMTP:rafiq9857_at_hotmail.com]
> > Gesendet: Donnerstag, 22. Februar 2001 15:56
> > An: Multiple recipients of list ORACLE-L
> > Betreff: Slow performance of code using dblinks ver 8.1.6.2
> >
> > Hi All
> > I am placing my following question once again as no response received
> so
> > far.....I just wanted to know any possible problem when using db_links
> > from
> > 8.1.6.2 database to 7.3.4.5 database. No specific reference found at
> > metalink....
> >
> > Thanks
> > Rafiq
> >
> >
> > Reply-To: ORACLE-L_at_fatcity.com
> > To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > Date: Wed, 21 Feb 2001 07:15:30 -0800
> >
> > Platform HP 11.0.32
> > Database 8.1.6.2
> >
> > Recently we have migrated our Datawarehouse application/database from
> > HP-10.20/Oracle 7.3.4.5 to above platform and testing code to check any
> > possible problem/performance issues.
> >
> > General complaint is about those code using dblinks/network. These
> codes
> > were running fine in previous environment. We are getting data from
> > 7.3.4.5
> > databases.
> >
> > Please advise where to look to fix this issue. As per Unix Admin packet
> > size/other network configuration is same as other boxes with HP-10.20
> and
> > version 7.3.4.5.
> > In one situation a 15 minutes job takes more than 5 hours and still not
> > finishing.
> > Any pointer/help shall be appreciated.
> > Regards
> > Rafiq
> >
> > _________________________________________________________________
> > Get your FREE download of MSN Explorer at http://explorer.msn.com
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Mohammad Rafiq
> > INET: rafiq9857_at_hotmail.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
> > _________________________________________________________________
> > Get your FREE download of MSN Explorer at http://explorer.msn.com
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Mohammad Rafiq
> > INET: rafiq9857_at_hotmail.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Haunschmidt Andreas VASL/FAS
> INET: Andreas.Haunschmidt_at_voest.co.at
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
> _________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Mohammad Rafiq
> INET: rafiq9857_at_hotmail.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Haunschmidt Andreas VASL/FAS
  INET: Andreas.Haunschmidt_at_voest.co.at

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).