Title: Extent sizes when using LMT with autoallocate clause
From
memory...
16
extents of 64K = 1 meg
63
extents of 1m = 63 meg (64 total)
120 extents of 8m = 960 meg (1024 meg or 1 gig
total)
Additional extents are 64m (I never found an upward bound in testing...)
*This is undocumented by
> case
> when initial_extent < 1m then
> case when extents < 16 then next = 64k,
>when extents < 80 then next = 1m,
>when extents < 200 then next = 8m,
>else next = 64m
> when initial_extent >= 1m then
> case when extents < 64 then next = 1m
Title: Extent sizes when using LMT with autoallocate clause
Hi!
I was wondering what the allocated extent sizes for locally managed tablespaces with the autoallocate clause are? The first extents are 64k in size. How many 64k chunks are allocated? What are the next sizes?
CREATE
