Tablespace Uniform
Hi every body,
we are using a storage model, which use several tablespaces with different initial size (Uniform).
on our database (OLAP) (4 TB) we have 6 tablesapces (small datafile) !
| Name | Type | Uniform |
|---|---|---|
| DATA_LVL01 | DATA | 64K |
| INDEX_LVL01 | INDEX | 64K |
| DATA_LVL02 | DATA | 1M |
| INDEX_LVL02 | INDEX | 1M |
| DATA_LVL03 | DATA | 8M |
| INDEX_LVL03 | INDEX | 8M |
we have scheduled a procedure to run twice every month, to move the segments from low level to higher one, depending on the segment size!
for example if a table partition size in DATA_LVL01 tablespace is more than 100MB, then this procedure will move this partition to DATA_LVL02 tablespace.
1