I think if you want to put in one tablespace alter tablespace´s parameter
minimum extent 128K
this will esure all extents are 128K thus avoiding fragmentation, the deallocated extents will be reused
have different inital extents but multiples of smallest extent size and coalesce every once a while, once the extent issue is done just adjust pctfree and pctused parameters for respective table with high inserts/updates/deletes.
currently all the tables have different storage and block utilization parameters.I wanted to to bring some uniformity (if necessary!)
so for first alternative, if I just change the min extents for tablespace is that sufficient ?
In the second alternative what initial extents are recommended if we want to group separately?
can u elaborate on 'once the extent issue is done....'?
(dont confuse with minextents parameter, they are totally different)
all extents will be multiples of 128K no matter the size of initial and next.
I said when extent issue is done, it means after you have set initial next at tablespace level. When those are done the only thing we can change are pctfree and pctused parameters to accomodate updates/inserts/deletes (this is for both cases by the way)