RE: RE: Separate Indexes and Data

> -----Original Message-----
> From: rgaffuri_at_cox.net [mailto:rgaffuri_at_cox.net]
> Sent: Tuesday, September 30, 2003 1:29 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: RE: Separate Indexes and Data
>
>
>
> >
> > From: "Jesse, Rich" <Rich.Jesse_at_qtiworld.com>
> > Date: 2003/09/30 Tue PM 02:09:32 EDT
> > To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > Subject: RE: RE: Separate Indexes and Data
> >
> > > -----Original Message-----
> > > From: rgaffuri_at_cox.net [mailto:rgaffuri_at_cox.net]
> > > Sent: Tuesday, September 30, 2003 12:50 PM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: Re: RE: Separate Indexes and Data
> > >
> > >
> > > the defrag paper was written back in 1998 I believe. Uniform
> > > extents were a good solution pre-9i. We use them here on our
> >
> > I haven't been following this thread closely, but why are
> uniform extents no
> > longer good for 9i?
> >
> Kyte recommends using auto-segment management

Actually, the qualifier from Mr. Kyte is to "use system-managed LMTs when you not know how big your objects will become" (Ch 3, p19). I don't think this is a blanket statement not to use uniform extents. Our DB tables grow linearly (near enough anyway) to correctly estimate storage requirements for at least a fiscal year. Granted, there is a minimal amount of play involved, mostly revolving around how our business expects to be doing in the coming year.

I'm much more concerned about fragmentation left from the creation and deletion of DB objects. With LMTs, it's one thing I don't have to worry about.

I'm looking forward to LMTs in 9iR2! :)

Rich

Rich Jesse                           System/Database Administrator
rjesse_at_qtiworld.com                  Quad/Tech Inc, Sussex, WI USA

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: Rich.Jesse_at_qtiworld.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).