Re: Database Fragmentation

From: David Sisk <davesisk_at_ipass.net>
Date: Sun, 18 Jul 1999 19:45:39 -0400
Message-ID: <Kxtk3.245$w3.456@news.ipass.net>

Hi:

If you've *standardized* your extent sizes, you'll get lots of space reuse on tables, so table fragmentation shouldn't be much of a problem. Space from deleted rows in indexes isn't reused until 8.1, so you will get index fragmentation. Luckily, you can easily fix this by running "ALTER INDEX indexname REBUILD tablespacename" on each affected index. Be sure to specify the tablespace name or it will rebuild on the default user's tablespace.

Good luck!

--
David C. Sisk
The Unofficial ORACLE on NT site
http://www.ipass.net/~davesisk/oont.htm

newsreader wrote in message ...
>We are unsing Oracle 7.3.x and we are concerned about Fagmentation and
>Performance.
>
>
>Our Database will contain aproximitely 2 Million Sets of Data. Every week
we
>get additional 200.000 Data-Sets. We want to delete about 200.000 old Sets
>every week too. Is there going to be an issue with Database Fragmentation
>and Performance and how can we handle this.
>
>
>
>Any suggestions are greatly appreciated.
>
>
>Wolfgang Niefert
>
>
Received on Sun Jul 18 1999 - 18:45:39 CDT