Peter Blood - Oracle Tips

Uniform extents on your tablespaces

To easily obtain uniform extents on each tablespace use locally managed tablespace 8i/9i feature and specify uniform extent size.

Example - to create a tablespace where all extents are 1 megabyte size, try the following:

CREATE TABLESPACE TEST DATAFILE '/oracle/data/test_000.dbf' SIZE 1001M
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;

There are several advantages in using uniform extent size tablespaces, namely minimizing tablespace fragmentation and space wastage.

posted by Pedro Oliveira @ 3:10 AM