I *knew* I had talked to someone about a formula for this.... thanks!
I'm only half as crazy as I thought I was.
- "Daniel W. Fink" <optimaldba_at_yahoo.com> wrote:
> From my testing, I have found the following autoallocate alogrithm.
> The
> first 16 extents are 64k in size. The subsequent allocation method is
>
> the next 63 extents of 1m, the next 120 extents of 8m and all
> additional
> extents at 64m. I have tested this with segments in excess of 100
> gigabytes and I did not find a new extent size. The first 3 sizes are
>
> documented by Oracle, the last one I found by testing and have
> verified
> from other research, though the author/website escapes me at the
> current
> time.
>
> --
> Daniel W. Fink
> http://www.optimaldba.com
>
> IOUG-A Live! April 27 - May 1, 2003 Orlando, FL
> Sunday, April 27 8:30am - 4:30pm - Problem Solving with Oracle 9i
> SQL
> Wednesday, May 1 1:00pm - 2:00pm - Automatic Undo Internals
>
>
> Jamadagni, Rajendra wrote:
>
> > Rachel,
> >
> > in case of auto allocate, oracle used 4 or 5 (experts don't even
> agree
> > on if it is 4 or 5) fixed sizes (64k ...) and based on number of
> > existing extents it will choose when an extent of next size should
> be
> > allocated. The problem is there is no set formula (or I haven't
> seen
> > one agreed upon by Oracle ... the answer from Oracle is always
> fuzzy
> > about this).
> >
> > That's why, I don't know if the next extent of my table will be 64K
> or
> > 1M ... if someone knows a formula, I can write a quick script and
> > things would be easy ... but due to lack of formula, everything is
> a
> > hypothesis ..
> >
> > In case of dictionary managed, you have next extent size and pct
> > increase and you can predict what the next extent would be. This is
>
> > also true if you use uniformed extents in LMT. But it isn't easy in
>
> > LMT and auto allocate. It is probably as predictable as expecting a
>
> > straight like from a drunken monkey with a crayon.
> >
> > Raj
> > -------------------------------------------------------------
> > Rajendra dot Jamadagni at espn dot com
> > Any views expressed here are strictly personal.
> > QOTD: Any clod can have facts, having an opinion is an art !!
> >
>
>------------------------------------------------------------------------
> >
>
>********************************************************************This
> e-mail message is confidential, intended only for the named
> recipient(s) above and may contain information that is privileged,
> attorney work product or exempt from disclosure under applicable law.
> If you have received this message in error, or are not the named
> recipient(s), please immediately notify corporate MIS at (860)
> 766-2000 and delete this e-mail message from your computer, Thank
>
you.*********************************************************************2
> >
> >
>
>
>
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Rachel Carmichael
INET: wisernet100_at_yahoo.com
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: 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 Mon Mar 10 2003 - 13:59:13 CST