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 -- //www.freelists.org/webpage/oracle-l