This discussion is archived
1 2 Previous Next 16 Replies Latest reply: Mar 27, 2013 1:18 AM by Radek Go to original post RSS
  • 15. Re: AUTOALLOCATE vs UNIFORM SIZE
    Hemant K Chitale Oracle ACE
    Currently Being Moderated
    Very strong argument, but for first 16 tables. All next tables will start from 1MB, then 8MB, then 64MB initial extent anyway, correct?
    I think that you misunderstand AUTOALLOCATE.

    The "first 16" (and subsequent) extent sizes rule is per object (segment).

    Table A starts with 64KB extents and allocates 16 extents till it hits a size of 1MB. It then starts using 1MB extents and so on.
    At the same time, Table B in the same tablespace also starts with 64KB extents and allocates 16 extents till it hits a size of 1MB .. and so on.
    Thus you could have a few thousand tables all with 64KB extents (between 1 and 16 such extents each) in the same tablespace.


    Hemant K Chitale

    Edited by: Hemant K Chitale on Mar 27, 2013 10:25 AM
  • 16. Re: AUTOALLOCATE vs UNIFORM SIZE
    Radek Newbie
    Currently Being Moderated
    Thank you
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points