While Oracle says you can have "unlimited" extents, practically it doesn't hand more than at MOST between 1000 and 4000 extents in a table.
And you can just adjust your baby bear, mama bear and papa bear extent sizes in all your tablespaces, no one says the extent sizes are fixed! Geez, years from now, when someone talks about the Goldilocks method of extent management I'll be able to say I started it all. then I'll start running for my life. :) Rachel --- "Jesse, Rich" <[EMAIL PROTECTED]> wrote: > So, proper LMT means no LBE? ;) Great analogy! All the > head-spinning and > the green projectile vomiting and such... > > BTW, yes that is a good paper. I've read it and am trying to deal > with the > extent sizes as it applies to our DB, as only about two dozen of the > 800+ > tables are larger than 128MB and none are larger than 4GB. So, > either I > consider making the Large LMTs smaller, or maybe our li'l 25GB DB > doesn't > need a "Papa Bear". > > Or maybe I just need to get used to the idea of having more than a > couple > hundred extents... :) > > Thanks! > > Rich Jesse System/Database Administrator > [EMAIL PROTECTED] Quad/Tech International, Sussex, > WI USA > > > -----Original Message----- > > From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, September 03, 2002 3:04 PM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: automatic segment space management > > > > > > Rich - Good point. Yes, I create all the tables here, at least in > > production, and I probably wouldn't use autoextend if the > > situation were > > otherwise. The other thing to consider is if you are using > > uniform extents, > > by definition you have bought into the philosophy that you > > can have many > > extents and your database will not do a Linda Blair Exorcist > > imitation on > > you. If we use the guideline that the number of extents > > should be not many > > more than 1,000, then the 128K extent will get you 128M, > > which is good for > > most tables. > > While we are on the subject, anyone considering switching > > to LMTs should > > carefully read "How to Stop Defragmenting and Start Living" > > by Juan Loaiza, > > Rosanne Toohey, Bhaskar Himatsingka. You can find a copy on > > http://www.hotsos.com. Trying to implement a philosophy without > fully > > understanding it is a recipe for failure. > > > > Dennis Williams > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Jesse, Rich > INET: [EMAIL PROTECTED] > > 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: [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). __________________________________________________ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] 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: [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).
