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

  • From: "Jared Still" <jkstill@xxxxxxxxx>
  • To: oradba.la@xxxxxxxxx
  • Date: Tue, 15 May 2007 12:32:10 -0700

On 5/15/07, Manjula Krishnan <oradba.la@xxxxxxxxx> 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

Other related posts: