Disk Space Full

When a disk is out os space, the database hungs or is unreachable and the Oracle DBA wants to find where are the large files to move or delete them. For example:


$ df –h
--> show 100% used

-- Find first 15 large files:
$ cd "My file system full"
$ find . -ls | sort -nrk7 | head -15
montreal.zip
quebec.zip
laval.zip
saint-eustache.zip
oracle-dba-montreal.zip
results.zip

-- Find first 15 large folders on Solaris (useful for small but big amount of files )
$ du -o . | sort -nr | head -15
(other O/S replace -o by -S)

Author: Vincent Fenoll – Montreal

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.