Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: any work-around to turn off .aud files generation?

Re: any work-around to turn off .aud files generation?

From: Mladen Gogala <mgogala_at_verizon.net>
Date: Thu, 02 Nov 2006 23:50:04 -0500
Message-id: <1162529404l.3126l.0l@medo.noip.com>

On 11/02/2006 08:41:52 PM, PRAVEEN KC wrote:
> hi
>
> I'm running oracle apps on 10g and have the default
> "audit_sys_operations=FALSE". I 'm aware that "Connections to the instance
> with administrator privileges" generates the .aud files.
> Just curious to know if there is any work-around to bypass this (at least
> would like to do on the development instances).
>

su - oracle
crontab -l> /tmp/crontab.oracle
echo '0 0 * * * find /aud/dir -name "*.aud" -mtime +1 -exec rm -f {} \;'>>/tmp/crontab.oracle crontab /tmp/crontab.oracle

This will run every day at midnight, thereby preventing your oracle directories to turn into pumpkins. There are mysterious and arcane ways of configuring the timings slightly differently. These mysterious ways can be learned by typing "man 5 crontab".

-- 
Mladen Gogala
http://www.mladen-gogala.com

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Nov 02 2006 - 22:50:04 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US