Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Performance Issues on Insert Statement to Remote Table

Re: Performance Issues on Insert Statement to Remote Table

From: Rob F <robfegan_at_coracle.fsbusiness.co.uk>
Date: 20 Mar 2006 06:18:07 -0800
Message-ID: <1142864287.913713.246070@i40g2000cwc.googlegroups.com> 





Have you run explains on the 2 queries to check that they are indeed
using the same execution plans for the select part of the query?



Can you confirm whether the table being inserted into is local and the
query accesses the remote view, or is the table being inserted into
remote also?



Are there any triggers which fire for row inserts on the table being
inserted into?



Also, probably not much help for this particular instance, but it's
PARALLEL, not PARRALLEL.



Regards,


  Rob
Received on Mon Mar 20 2006 - 08:18:07 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US