Hi
I have many fragmented tables and indexes in the database and also chained rows in some tables. What i have to do in order to tune those tables and indexes.
There are few solution ihave in mind
1. change the pct increase to 1 for the tablespaces which will do the coleasing but i don't know how often it will do it.
2.recreate the tables and indexes with the bigger initial and next extents size.

but there is one problem i can havein future if i have bigger size of initial and next extent then i might have problems when those indexes and tables will try to create the next extent. so i might receive the error that unable to allocate the next extents.

please reply me what to do in order to do the tuning of those tables and indexes which are fragmented.

Cheers
UKDBA