Correct size for datafile. Part 01

In this example we lost one extent (128M) because oracle uses in locally managed tablespaces with a UNIFORM extent size at least 64K per datafile  for Metadata Blocks.

create tablespace TBS_TEST_BAD

datafile '/oradata/TEST/lm02.dbf' size 524288K -- <-- 512M

extent management local uniform size 128M;

Tablespace                        Size MB    Free MB    Used MB Used Pct

------------------------------ ---------- ---------- ---------- --------

TBS_TEST_BAD                          512        384        128 25 %

Then datafile has to be a multiple of their extent size + 64K.

create tablespace TBS_TEST

datafile '/oradata/TEST/lm01.dbf' size 524352K -- <-- 512M + 64K

extent management local uniform size 128M;

Tablespace                        Size MB    Free MB    Used MB Used Pct

------------------------------ ---------- ---------- ---------- --------

TBS_TEST_GOOD                      512.06        512        .06 .01 %

NOTE:

In ASM, oracle  recommend to use AUTOALLOCATE tablespaces, not UNIFORMSIZE tablespaces.

You can read this.

Based on the following document:

Locally Managed Tablespace with Uniform Extent Size Need 64 K Per Datafile [ID 111666.1]

Regards,

Eini Trujillo