RE: Slow performance of code using dblinks ver 8.1.6.2

[Haunschmidt Andreas VASL/FAS]

Hi Rafiq!

Thanks for sending me your PL/SQL code.
You do a lot of aggregations over the dblink, also
remote joins can be slow.

Suggestion: 
  Reverse the situation, do the selects local and insert remote.
  Run the code on the 7.3.4.5  instance without @OLAP_APPS_LINK in selects
  and insert into the same table  (now with a new database link for the
8.1.6.2 instance):
  INSERT INTO HAR_ATB_ITEMS@8_1_6_2_instance_dblink ...
  You can still invoke the code from the 8.1.6.2 instance, if you create a
procedure 
  on the  7.3.4.5  instance:
  replace  the 'DECLARE' by 
 'CREATE OR REPLACE PROCEDURE MYPROC IS'
  and invoke it remotely from the 8.1.6.2 instance:

BEGIN
   MYPROC@8_1_6_2_instance_dblink
END;
/


This should execute the queries in the local instance only and 
thus consume only the local resources.
I'd like to know , if this affects performance.

Good Luck!

Andreas


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