Re: create local tablespace sanity check

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

"Fraser McCallum" <fmcc_at_NOSPAModbaguru.com> wrote in message news:YfzG7.10345$5N2.61328_at_NewsReader...
> Mike,

> Note, you will not quite get the full 2G/256K worth of extents in
> your datafile as Oracle allocates some space in the tablespace for
> the extent management, hence the locally managed. Also F.Y.I.
> locally managed does not require uniformed size.
>

As Fraser is referring to, there is a bitmap at the beginning of each datafile in a LMT that is used to manage the tablespace. You should add 64k to the size of each datafile in an LMT to accomodate this bitmap. Otherwise it will use an entire extent. I've worked on some databases where the DBA got bitten by this. He create a 2g datafile with uniform extent size of 500m and did not add 64k. The end result was he wasted 500m of space for a 64k bitmap. - --
Chuck Hamilton
"Do not be deceived, God is not mocked; for whatever a man sows, this he will also reap. (Gal 6:7 NASB)

-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com>

iQA/AwUBO+rhO2m5A4kkb4ZsEQI3gQCffB8z8ZFfEFrWYv+XFyd8V+GpixoAoMwv wt0VirrSgR6X2y5lc8kxSvcm
=MZMC
-----END PGP SIGNATURE----- Received on Thu Nov 08 2001 - 13:47:10 CST