Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Optimize
Oracle 8.1.5 Enterprice Edition
Oracle Index Tuning Wizard 2.0.4
"Ban Spam" <ban-spam_at_operamail.com> skrev i meddelandet
news:Xns9130ADFB6E7CESunnySD_at_24.0.3.73...
> "Roland Carlsson" <roland.c_at_swetravel.se> wrote in
> news:3bbc2420$1_at_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
> >
> >
> >
>
> I guess I have not kept up on my Oracle readings recently.
> On which OS is Oracle installed & which version or Oracle?
> What manual describes "Oracle Index Tuning Wizard" & what's
> it supposed to do?
Received on Fri Oct 05 2001 - 02:22:22 CDT