Re: maxextents

On Thu, Mar 3, 2011 at 6:34 PM, P D <pdba1966@xxxxxxxxxxx> wrote:

>  When I use OEM and try and set Maximum Size to Unlimited and hit apply,
> it doesn’t show up with the Unlimited bullet highlighted.   Instead it
> shows up as Value=32767MB.   Why is that?   Is 32GB the largest a datafile
> is ever supposed to be?
>

Datafile size answer.

A smallfile datafile can only ever be (2^22 - 1) *blocks* in size. For 8k
blocks that's 32gb. This is so that block addressing works correctly when a
tablespace had multiple files. For a bigfile tablespace the limit is 2^32
(don't need to worry about the file). Presumably for Oracle 42 when no-one
uses 32bit pointers any more the limit will be 2^64. :)

Maxextents.

Maxextents applies *only* to objects and not to datafiles/tablespaces.
In the bad old days objects inherited their storage clause from the
tablespace definition, so maxextents there is only ever intended as the
default for new objects.


-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

Other related posts: