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).