Re: Datafile size - Is bigger better?

On 11/14/06, Wolfgang Breitling <breitliw_at_centrexcc.com> wrote:
>
>
> That is not true. The bitmap(s) for managing the space are fixed at 64K.
> If you create the datafiles for LMTs as an integral multiple of the uniform
> extent size + 64K, you can use the full size of the tablespace. If not
> Oracle will take the first extent and use 64K of it for the bitmap but the
> remainder is not usable - until you extent the datafile size by 64K:
> ...
>
> But by adding the 64K required for the bitmap to the datafile the
> "missing" extent magically appears.
>
>

Thank you Wolfgang.

I am pretty sure I knew that at one time.

I *hate* remembering details after they have been pointed out. :)

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l