AW: Slow performance of code using dblinks ver 8.1.6.2

[Haunschmidt Andreas VASL/FAS]

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:[EMAIL PROTECTED]]
> 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: [EMAIL PROTECTED]
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> 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: [EMAIL PROTECTED]
> 
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
> 
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).