Monitoring growth of dba_extents and dba_free_space
could be enough if extents size is small .
if u have a very large initial extent then may physically checking the average approximate size of the indexed row with rowid may help u in monitoring the growth of the index.




Reply With Quote