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: Large Parse times

Re: Large Parse times

From: Asko Tiidumaa <askot_at_math.ut.ee>
Date: 9 Jul 1998 13:41:34 GMT
Message-ID: <6o2hae$3qu$2@kadri.ut.ee> 





> Increase the size of the SHARED_POOL , pin any frequently used packages,


> sounds like a problem with fragmentation or insufficiently size SGA.





I had the same-alike problem. I created statistics for all tables involved
in query, and the problem disappeared. But then the optimizer started to
use NESTED_LOOPS instead of hash joins.




Asko Tiidumaa

Received on Thu Jul 09 1998 - 08:41:34 CDT












Original text of this message













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