Heck with that. I always try to make NEXT = 100% of INITIAL extent. I also make all segments
within a given tablespace have the exact same extent sizes to avoid fragmentation.
- "McGlaughlin,Stewart" <mcglaughlin_at_attws.com> wrote:
>
> 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).
> --
> Author: McGlaughlin,Stewart
> INET: mcglaughlin_at_attws.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).
Do You Yahoo!?
Talk to your friends online and get email alerts with Yahoo! Messenger.
Received on Thu Apr 27 2000 - 09:59:27 CDT