cool !
"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message
news:1017091312.24426.1.nnrp-07.9e984b29_at_news.demon.co.uk...
>
> 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:33:35 CST
