RE: Tablespace reorg tools

From: McGlaughlin,Stewart <mcglaughlin_at_attws.com>
Date: Thu, 27 Apr 2000 09:16:15 -0400
Message-Id: <10480.104300@fatcity.com>

George,

Let's say we have a table that is initial sized with INITIAL=160K and NEXT=16K and PCTINCREASE=0. A few weeks/months we noticed the table has allocated 100+ extents. If we reorg with exp COMPRESS=Y, drop/rebuild the table - the INITIAL might be resized to 2M but the NEXT is still 16K! This, to me, is a bad thing because in a few weeks/months, assuming the same growth,
we'd be reorging again. I always try to make my NEXT extent = 10% of INITIAL extent with PCTINCREASE=0. YMMV

---

Stewart McGlaughlin
Oracle DBA
On-site at AT&T Wireless Services
Oracle Links @ http://www.pobox.com/~dba/oracle stewartm_at_iname.com

> -----Original Message-----
> From: George.Brennan_at_warnermusic.com [SMTP:George.Brennan_at_warnermusic.com]
> Sent: Thursday, April 27, 2000 8:44 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Tablespace reorg tools
>
>
> > Deepak,
> >
> > I believe COMPRESS=Y will resize the initial extent, but the next
> > extent will remain the same size. If initial was 16K and next was
> > 16K, and you have inserted a few thousand records, and export
> > with COMPRESS=Y, oracle will recalculate the initial (so all records
> > fit in the initial extent) *but* the next extent will still be 16K.
> > This is usually a *bad* thing.
> >
>
> Ok, I'll bite, why is it usually a *bad* thing?
>
> George.
>
>
> --
> Author:
> INET: George.Brennan_at_warnermusic.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Thu Apr 27 2000 - 08:16:15 CDT