Originally posted by: salmanucit77

Hi,
I am using AIX 6.1 on P series server. I have a file system /oracle/D01 and it has started increasing automatically since yesterday. I have allocated more space to it so that nothing wrong happens but file system usage is increasing. I have some directories in /oracle/D01 which also contain different mount points. If i use "du -sk" command for /oracle/D01 again and again, size is not increasing for this directory but if i issue "df -g", it continuously shows the percentage used for this file system is increasing. i dont know what to check and what to do. Even i tried using "ls -altr" command but all files on this file system have same size and are not increasing.
any idea what is going wrong? Please see attached file which demonstrats the usage of "du -sk", "ls -altr" and "df -g"

Thanks

Salman
#AIX-Forum

Originally posted by: Kosala

Unix house keeping 101.... use find command.

I generally use from the suspected filesystem path:

1. find . -atime -1

this will tell you what files are recently accessed (even for reading) withing last 1 day(s).

1. find . -mtime -1

last file modifications within 1 day(s). This includes file writes.

ctime will track the inode changes, that would be file moves (if it across file systems) or newly created. RTFM for more control of the command
#AIX-Forum

Originally posted by: salmanucit77

Hi,
Thanks for your help. Following is the findings. Support person from our vendor has given us following feed back. Inode 271, 272, 262, 259 are the files which are not visible with any command but still these are growing continuously. Since he is our vendor, he migh not be telling us how to find these files. Can you help me how to get following output. We have also found that these are processes from Oracle database but we are still not sure why these processes are creating files here in /oracle/D01 directory and why these files are increasing in size.

inode=451 size=566 fd=5 512252
inode=451 size=566 fd=5 516348
inode=271 size=493600399 fd=5 774362
inode=272 size=930754294 fd=5 958564
inode=262 size=328421147 fd=5 1032210
inode=259 size=70997793 fd=5 1085688
#AIX-Forum

Originally posted by: tony.evans

Two possible reasons why space is being used by files you can't 'see'.

1. Someone rm'd the file while it was still open and in-use by Oracle, and Oracle is quite happily chucking content at the file descriptor it has, and AIX is quite happily writing the content out to the filesystem, but the directory entry is now gone.

2. Filesystem corruption.
#AIX-Forum

Originally posted by: Kosala

if you're in a situation such as tony.evans described, you should be able to track it with lsof. I can't simulate a similar scenario right now under AIX but, lsof on Linux can track the situation.

1. lsof | grep oracle

or even the inode number might work. If this is the situation, once the file is closed (shutdown oracle), that data will be lost in the volume.
#AIX-Forum

Originally posted by: SystemAdmin

You could try something like this:

find /oracle/D01 -inum 271 -exec ls -l {} \;

As Tony pointed out the file descriptors for these deleted files "may be" still open by oracle. Is it possible to restart oracle?

You could stop oracle and use find the same way to check if the file descriptors still exist.

r/
R
#AIX-Forum