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