Path: news.f.de.plusline.net!news-fra1.dfn.de!keepthis.news.telefonica.de!telefonica.de!news.cs.univ-paris8.fr!proxad.net!cleanfeed2-b.proxad.net!nnrp9-2.free.fr!not-for-mail From: "Eric" Newsgroups: comp.databases.oracle.server References: <45c2604f$0$21113$426a74cc@news.free.fr> <1170372675.84902@bubbleator.drizzle.com> Subject: Re: when rebuild IOT ? Date: Fri, 2 Feb 2007 07:54:33 +0100 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1807 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1896 X-Antivirus: avast! (VPS 000709-2, 01/02/2007), Outbound message X-Antivirus-Status: Clean Lines: 44 Message-ID: <45c2df90$0$10072$426a74cc@news.free.fr> Organization: Guest of ProXad - France NNTP-Posting-Date: 02 Feb 2007 07:52:00 MET NNTP-Posting-Host: 82.235.189.18 X-Trace: 1170399120 news-2.free.fr 10072 82.235.189.18:1114 X-Complaints-To: abuse@proxad.net Xref: news.f.de.plusline.net comp.databases.oracle.server:193485 "DA Morgan" a écrit dans le message de news:1170372675.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 > damorgan@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