Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Next extent size - Locally managed tablespace
No. Leave it alone. Automatic means automatic. Oracle takes care of it.
It starts out with a small extent and as you add more data to that table the
extents get larger. The multiples that the extents get larger are sized
correctly to not have holes(that can't be filled) if tables are dropped.
Jim
-- Replace part of the email address: kennedy-down_with_spammers_at_attbi.com with family. Remove the negative part, keep the minus sign. You can figure it out. "Rogbaker" <Rogbaker_at_gdi.net> wrote in message news:e40a12ea.0303200732.2055005a_at_posting.google.com...Received on Thu Mar 20 2003 - 10:29:07 CST
> Oracle 8.1.7 on windows 2000:
> Tables that I create in a tablespace that is defined as "Locally
> Managed Extent Management" and has "Automatic Allocation" have a NEXT
> extent size set to 0 (zero) no matter what I try to set it to. What
> does this '0' mean exactly, is this bad? Should I be using Dictionary
> managed extent management?
> THanks,
> Roger