Re: maxextents
Date: Thu, 3 Mar 2011 21:14:47 +0000
Message-ID: <AANLkTinv4HgPzNHWE8d7312T6Urn_OGS3KnmY4jOZcDD_at_mail.gmail.com>
On Thu, Mar 3, 2011 at 6:34 PM, P D <pdba1966_at_hotmail.com> 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 -- http://www.freelists.org/webpage/oracle-lReceived on Thu Mar 03 2011 - 15:14:47 CST