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 -> Optimize

Optimize

From: Roland Carlsson <roland.c_at_swetravel.se>
Date: Thu, 4 Oct 2001 10:55:59 +0200
Message-ID: <3bbc2420$1@d2o21.telia.com>


Hi!
I'm trying to run Oracle Index Tuning Wizard to see if my if I have made any misses with my manual indexing. The problem is that the database has been running for a while so the ITW have a lot of statistics to walk though. Is there a way to remove all statistic or even better remove all statistics that is older than a month so that I can get ITW recomendation on fairly fresh data. Right now ITW has been running for over 24 hours and I still doesn't see any end to it.

Thanks in advance
Roland Carlsson Received on Thu Oct 04 2001 - 03:55:59 CDT

Original text of this message

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