planing tablespaces - please comment

List,
please comment

i do the following when planing tablespaces for the schema

1. divide all tables into three categories small, medium, large according to the estimated data volume
2. create 3 tablespaces to hold the above 3 kinds of tables. data_small, data_med, data_large

all tablespaces are created with uniform extent size (8i)... example:...

data_small extent uniform size 32K
data_med extent uniform size 1M
data_large extent uniform size 25M

i keep the max number of extents to around 30, if a table exceeds that limit then i move the table to the higher level tablespace

i apply the same logic to indexes also...

is the right way to plan tablespaces ?

TIA Received on Thu Oct 05 2000 - 04:03:52 CDT