Tablespace used space size increasing
Hi,
RDBMS Version : 10.2.0.1.0
Operating System Version : SunOS 5.10
I am facing a strange problem.
I am having around 50 tables in my tablespace. I am purging the data everyday and then reclaiming space by using "shrink space cascade".
The used space size should remain consistent with this activity but it is still increasing by 0.5% everyday. What could be the problem?
About 5-6 months back, are tablespace used space size had increased to around 94%. Then we did the purge and "shrink space" activity with whose help our tablespace used percentage dropped to 60%. It was consistent at this percentage. It was consistent for about 2 months. But then we had to load the database with some extra data (as required by our application) and since then it is increasing consistently by 0.5%(despite the daily purge activity).
RDBMS Version : 10.2.0.1.0
Operating System Version : SunOS 5.10
I am facing a strange problem.
I am having around 50 tables in my tablespace. I am purging the data everyday and then reclaiming space by using "shrink space cascade".
The used space size should remain consistent with this activity but it is still increasing by 0.5% everyday. What could be the problem?
About 5-6 months back, are tablespace used space size had increased to around 94%. Then we did the purge and "shrink space" activity with whose help our tablespace used percentage dropped to 60%. It was consistent at this percentage. It was consistent for about 2 months. But then we had to load the database with some extra data (as required by our application) and since then it is increasing consistently by 0.5%(despite the daily purge activity).
0