New 10g Tablespace Sizing
Hi all,
I am migrating from 8i to 10g. I need to get the most out of the space in each datafile. I know space is cheap. But, we are paying someone to host the storage for us and do want to waste any space, it is expensive.
Let starts with a small example:
CREATE TABLESPACE lmtsmall DATAFILE '/u02/oracle/data/lmtsmall01.dbf' SIZE 5120k
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128k
SEGMENT SPACE MANAGEMENT AUTO;
How much space do I need to add for the extent bitmap, so I use all the space in the file? Right now I should get 40 extents, but what about the bitmap?
Thanks,
Kathy