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).