Re: /oracle file system keeps growing
From: Justin Mungal <justin_at_n0de.ws>
Date: Thu, 16 May 2013 22:18:48 -0700 (PDT)
Message-ID: <0b9ad1d2-6191-4aac-8655-3c695395625f_at_googlegroups.com>
On Thursday, May 16, 2013 10:52:55 PM UTC-5, zigz..._at_yahoo.com wrote:
> On Thursday, May 16, 2013 7:37:06 PM UTC-4, zigz..._at_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.
Date: Thu, 16 May 2013 22:18:48 -0700 (PDT)
Message-ID: <0b9ad1d2-6191-4aac-8655-3c695395625f_at_googlegroups.com>
On Thursday, May 16, 2013 10:52:55 PM UTC-5, zigz..._at_yahoo.com wrote:
> On Thursday, May 16, 2013 7:37:06 PM UTC-4, zigz..._at_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.
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. Received on Fri May 17 2013 - 07:18:48 CEST