Some confusion there.
If you use locally managed tablespaces, then
(typically) the first 64K is allocated for the extent
bitmap. Consequently if you set your filesize to
be N extents plus 64K, you don't waste space,
e.g. 2000MB + 64K gives you 10 x 200MB extents
and a 64K bitmap.
--
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Next Seminar - UK, April 3rd - 5th
http://www.jlcomp.demon.co.uk/seminar.html
Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Author of:
Practical Oracle 8i: Building Efficient Databases
koert54 wrote in message ...
>On the other hand - if you use uniform sized locally managed tablespaces,
>you'll lose every first extent of each datafile ... example
>a 20GB locally managed tablespace (uniform sized extent 200Mb) with 2GB
>datafiles -> 10 datafiles x 200Mb -> you lost 2GB of space for
>actual data.
Received on Mon Mar 25 2002 - 15:23:14 CST
