Re: Something is filling up my /oracle file system - URGENT

On 5/15/07, Manjula Krishnan <oradba.la_at_gmail.com> wrote:
>
> Hi all:
>
> Something is chewing up the space in /oracle filesystem (AIX). I have
> trimmed all the log files I could find. No sooner do I free up the space
> than it gets used up.
>
> Can you help me find what is writing to this file system?
>
>

Find all files written to in the last 5 minutes:

find /oracle -mmin -5 -type f
As this is AIX, that may not work.

Try:
find /oracle -mtime -1 -type f | xargs ls -ldtr

Find the files that appear to be growing and should not be.

ie. don't mess with Oracle data files

use fuser to find the process ID of the process(es) having the file open

/sbin/fuser <PID>

Check the man page for fuser, assuming AIX has it.

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l