> -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > 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" <[EMAIL PROTECTED]> > > Date: 2003/09/30 Tue PM 02:09:32 EDT > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > Subject: RE: RE: Separate Indexes and Data > > > > > -----Original Message----- > > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > > 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 [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
