Re: maxextents
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: pdba1966@xxxxxxxxxxx
- Date: Thu, 3 Mar 2011 21:14:47 +0000
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:
