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" <Rich.Jesse_at_qtiworld.com> 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
> 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).
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: wisernet100_at_yahoo.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).
Received on Tue Sep 03 2002 - 20:18:23 CDT
