/oracle file system keeps growing

[zigz...@yahoo.com]

I am on HP UNIX 11.23 using Oracle 11.7. My file system is 16GB and it is 95% full and keeps growing. I am however unable to find which file(s) are causing this problem.

I use find command:
Find . –mtime -2 –size +100 –print
I find all files which were modified in last 2 days whose size is greater than 100K and I do not see any.
There are various .trc and .trm but they are only occupying 100M space (du –a).

Are there things other than files which Oracle is creating on these file systems. If yes, how can I find them.

[zigz...@yahoo.com]

On Thursday, May 16, 2013 7:37:06 PM UTC-4, zigz...@yahoo.com wrote:
> I am on HP UNIX 11.23 using Oracle 11.7. My file system is 16GB and it is 95% full and keeps growing. I am however unable to find which file(s) are causing this problem. I use find command: Find . –mtime -2 –size +100 –print I find all files which were modified in last 2 days whose size is greater than 100K and I do not see any. There are various .trc and .trm but they are only occupying 100M space (du –a). Are there things other than files which Oracle is creating on these file systems. If yes, how can I find them.

Oh well, I found the problem, it was not big files but lots and lots of small files under adump directory. That's why I cound not find them using my find command.

[Justin Mungal]

That makes sense. I have some customers who use shell scripts to clean out the adump folder, but you can also use DBMS_AUDIT_MGMT, which is what I prefer since it can also clean the DB audit trail and is integrated with Oracle.

[Mladen Gogala]

Oh yes, looking for the files with -mtime -2 (newer than 2 days) will
surely help you. Have you ever thought of looking what actually consumes
the most of space? Something like this:

[oracle@medo oracle]$ du -sm *|sort -n
1 checkpoints
1 oradata
1 oradiag_oracle
1 oradiag_root
3 cfgtoollogs
9 admin
71 diag
4631 product
[oracle@medo oracle]$



What would you say, where should I look for the space issues? Those
configuration logs look suspicious enough, wouldn't you say?



--
Mladen Gogala
The Oracle Whisperer
http://mgogala.byethost5.com