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" <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] 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: [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).
