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