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:[EMAIL PROTECTED]] > 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: [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). > -- 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).
AW: AW: Slow performance of code using dblinks ver 8.1.6.2
Haunschmidt Andreas VASL/FAS Mon, 26 Feb 2001 10:16:24 -0800
- Re: AW: AW: Slow performance of code using db... Haunschmidt Andreas VASL/FAS
- Re: AW: AW: Slow performance of code usi... Mohammad Rafiq
