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

Re: Optimize

From: Roland Carlsson <roland.c_at_swetravel.se>
Date: Fri, 5 Oct 2001 09:22:22 +0200
Message-ID: <3bbd5fa7$1@d2o21.telia.com>


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

Original text of this message

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