UNIX: to Find Files Open After Being Deleted
cd to the concerned directory: >lsof | grep -i deleted | sort -r -s -n -k 7 OR > lsof | grep undotbs | grep delete The only way to regain the space back is to kill the processes that are running. The PID of the process is field 2. For example: oracle-psfsdb602.tmw.com::/rd320/oradata/fsprod/undo01>lsof | grep -i deleted | sort -r -s -n -k 7 oracle_12 12029 oracle 272u REG 253,6 33579606016 67108995 /rd320/oradata/fsprod/undo01/undotbs01.dbf (deleted) oracle_12 12033 oracle 268u REG 253,6 33579606016 67108995 /rd320/oradata/fsprod/undo01/undotbs01.dbf (deleted) oracle_12 12069...