RE: automatic segment space management

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
Rich.Jesse_at_qtiworld.com              Quad/Tech International, Sussex, WI USA

> -----Original Message-----
> From: DENNIS WILLIAMS [mailto:DWILLIAMS_at_LIFETOUCH.COM]
> 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: Rich.Jesse_at_qtiworld.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).