Quote Originally Posted by ams-jamali
Ixion..,

I had already told him about that,then showed him in GUI mode too, space that was released comparing with previous report but asked said try to repli @ OS level.
If there is no other way, i can go and say to him,it can not be replicated at OS level for such a small sizes.
That is the way Oracle functions. Releasing space back to the OS in general is a bad idea.

Here is why, When oracle creates a datafile it does so in one fell swoop, claiming pages from the OS as available(unless your using raw). Hopefully these pages are relatively contiguous as to avoid disk fragmentation. So releasing and acquiring disk pages by shrinking and expanding the oracle datafiles leads to disk fragmentation..