Oracle version is 11gr1, os is aix.
We have a 100 tb dataware house, tables are partitioned including indexes.
Every table drop data 6 month ago, and same with index. However our table tablespace did not see growing, but index tablespace kept growing, I have to keep adding spaces.
HOw to look at this? where to find the problem is?
Thanks in advance.