What have you attempted so far, other than posting this request twice? Everyone here (volunteers, all) are quite willing to help those who are willing to put forth some effort of their own.

And even if some is willing to to it pro bono, it would be totally dependent on both your OS and the full version of Oracle . . . neither of which you have revealed.

So you have purged millions of rows. Is this a permenant reduction in the number of rows, or will they just build back up over time? If the latter, why waste time reclaiming space just to have to start re-allocating it again?

Please explain in words, what you understand by "database total size". DB is not just about database files, there are several other files which consume the physical memory. I see you are on 10g, however, generally speaking, with newer versions, it keeps varying.

If you are specific about your question, you can expect a specific answer.