Database Administration (MOSC)

MOSC Banner

Tablespace used space size increasing

edited Nov 15, 2008 3:10AM in Database Administration (MOSC) 4 comments
 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).

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center