How often we have seen that We delete some Oracle Datafile or move a datafile (specifically Online Move in Oracle 12c) from one disk to another disk to release space on one of the Disk Mount point but even after successful move or delete, you do not see space getting free’d up.
Without going into detail of “Why space is not released even if we delete files?”, I will move to point about How can we forcefully get the space released instantly if it is not released automatically.
To do this, you need to find out the processes which are holding up to the “Deleted” files.
I had a mount point /BITST which was 100% full. I decided to move few datafiles of 40G each to another mount point.
Let’s move Datafile
Check the space now
Still the same..
Lets see, if the file is still present at the original location
No, the file which we have moved, is not there on original location.
Lets see what is holding up the deleted files.
using “lsof” shows us that there are still 4 processes which are holding up to the deleted/moved files.
You can use “kill” command to kill these processes.
Once you kill the blocking processes, Space will be released as seen in above screen shot.
Well explained, good post.