Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> 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-lReceived on Wed Nov 15 2006 - 12:31:18 CST
![]() |
![]() |