Path: news.f.de.plusline.net!news-fra1.dfn.de!newsfeed.hanau.net!news.tiscali.de!tiscali!newsfeed1.ip.tiscali.net!proxad.net!216.239.36.134.MISMATCH!postnews.google.com!p10g2000cwp.googlegroups.com!not-for-mail
From: "sybrandb" <sybrandb@gmail.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: when rebuild IOT ?
Date: 2 Feb 2007 01:19:25 -0800
Organization: http://groups.google.com
Lines: 64
Message-ID: <1170407965.818409.90130@p10g2000cwp.googlegroups.com>
References: <45c2604f$0$21113$426a74cc@news.free.fr>
   <1170372675.84902@bubbleator.drizzle.com>
   <45c2df90$0$10072$426a74cc@news.free.fr>
NNTP-Posting-Host: 192.33.238.6
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1170407971 18997 127.0.0.1 (2 Feb 2007 09:19:31 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 2 Feb 2007 09:19:31 +0000 (UTC)
In-Reply-To: <45c2df90$0$10072$426a74cc@news.free.fr>
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.1),gzip(gfe),gzip(gfe)
X-HTTP-Via: 1.1 PXYBEBR003
Complaints-To: groups-abuse@google.com
Injection-Info: p10g2000cwp.googlegroups.com; posting-host=192.33.238.6;
   posting-account=d8kqXg0AAADvDUR8IdYEU7pAZnZ1O2PC
Xref: news.f.de.plusline.net comp.databases.oracle.server:193490

On Feb 2, 7:54 am, "Eric" <o...@dba.com> wrote:
> "DA Morgan" <damor...@psoug.org> a =E9crit dans le message denews:1170372=
675.84902@bubbleator.drizzle.com...
>
>
>
>
>
> > Eric wrote:
> > > I'm on 9.2.0.5. I have noticed that some IOTs where taking as much 2 =
to
> 4
> > > times space as they should. Are we supposed to rebuild IOTs, and what
> are
> > > pros & cons about that ?
>
> > > Thanks,
>
> > > Eric
>
> > How are you determining the size they are supposed to be?
>
> > And ;-) how do you get enough free time to care?
> > --
> > Daniel A. Morgan
> > University of Washington
> > damor...@x.washington.edu
> > (replace x with u to respond)
> > Puget Sound Oracle Users Group
> >www.psoug.org
>
> Surprising answer for someone working in a university, loosing time for s=
uch
> answer :-).
>
> Not interested in finding that sometimes your 10Gb database could be only=
 3
> Gb ? so I believe that impacts performance. Besides, Oracle only says in
> documentation that IOT can be rebuilt online, but does not tell when this
> should be. Regarding sizing, there are simple formulas, like
> sum(column_length) ... and look before/after in the correct view after AL=
TER
> TABLE ... MOVE to find out that it really reduced by 2 to 4 (in my case) =
the
> size of IOT.
>
> Now, for someone really doing DBA job on Oracle, when do you decide to
> rebuilt IOT, and what are pros & cons about that ?
>
> Cheers,
>
> Eric- Hide quoted text -
>
> - Show quoted text -

Real DBAs do not bother, as they know disk is cheap and the wastage
will return soon, as they know the behavior of their applications.

Contrary to you, Daniel is a real DBA.

--
Sybrand Bakker
Senior Oracle DBA