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: Query takes too long to execute

Re: Query takes too long to execute

From: <mylesv_at_gmail.com>
Date: 17 Nov 2006 08:44:53 -0800
Message-ID: <1163781893.652285.192090@m73g2000cwd.googlegroups.com> 





dbms_stats.gather_system_stats did the trick.  The query still does a
full scan of ICAS_PRODUCTION, but it finishes in seconds instead of
minutes.  I'm not sure I understand this, but I'm happy it's back to
normal!



Thanks,


Myles
Received on Fri Nov 17 2006 - 10:44:53 CST












Original text of this message













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