Re: Q:Table Fragmentation. How do I reduce it?

From: R.Schierbeek <bytelife_at_worldonline.nl>
Date: 1998/03/06
Message-ID: <01bd48f9$1800bcc0$5b82f1c3@worldonline>#1/1

Hello Rao,

• first of all: calculate (or do a calculated guess) the size of your tables in advance
• Create an adequate "next extent" for a table for example: A- Initial 10000K , next 4000K is good, B- Initial 10000K , next 200K is a bad idea, C- Initial 1000K , next 10000K will take a lot of space but is better then choice B.
• Choose a good pctincrease value. 0% is trick, 50% is a compromise

Check out http://home.worldonline.nl/~bytelife/storage.htm for some more info
and some sql scripts for DBA's

Good luck.

---

Roelof Schierbeek, DBA
Bytelife BV
The Hague, Holland
email: bytelife AT worldonline.nl http://home.worldonline.nl/~bytelife

Rao Uppuluri <uppuluri_at_IDT.NET> wrote in artikel <6dn7nh$3tr_at_nnrp1.farm.idt.net>...
> Hi all
>
> Setup: Oracle 7.3.2.3 on HP-UX 10.20
>
> I have a table(s) with lot of extents allocated to it. These extents are
> small extents. The extents allocated are not all next to each other.
> Some are but not all. If I drop the table and recreate it, do I get a
> lot of "free space fragmentation"? How do I reduce the fragmentation of
> the table? Do I have to export and import the whole tablespace?? ( I have
> many of these tables with lot of extents allocated to them in the
 tablespace)
> Thanx in ADvance
>
> Rao Uppuluri
> (uppuluri_at_XidtX.net -- Please remove X's)
Received on Fri Mar 06 1998 - 00:00:00 CST