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: when rebuild IOT ?

Re: when rebuild IOT ?

From: sybrandb <sybrandb_at_gmail.com>
Date: 2 Feb 2007 01:19:25 -0800
Message-ID: <1170407965.818409.90130@p10g2000cwp.googlegroups.com>


On Feb 2, 7:54 am, "Eric" <o..._at_dba.com> wrote:
> "DA Morgan" <damor..._at_psoug.org> a écrit dans le message denews:1170372675.84902_at_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..._at_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 such
> 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 ALTER
> 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
Received on Fri Feb 02 2007 - 03:19:25 CST

Original text of this message

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