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

Home -> Community -> Usenet -> comp.databases.oracle -> Re: Performance problems with remote queries

Re: Performance problems with remote queries

From: Dave Steele <DKBSteele_at_aol.com>
Date: 26 May 2004 06:56:30 -0700
Message-ID: <17f9e4c6.0405260556.3e9fdfba@posting.google.com> 





We had something similar happening when testing our Applications that
run on 7.3.4 on a 8.1.7.4 Oracle database.  Some queries that
connected to a remote database went from 5 seconds to about 15
minutes.  The explain plan showed many hash joins in the queries.  We
had to set the init.ora parameter hash_join_enabled = false, and the
queries ran again in about 5 seconds.



Hope this helps,


David
Received on Wed May 26 2004 - 08:56:30 CDT












Original text of this message













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