If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

How can I stop .aud files from generating.

We're running 10.2.0.2 RAC on Solaris 2.9 using GRID control.

I have a question about .aud audit files the instances are generating. Since our GRID CONTROL connects constantly we generate multiple .aud files in both the $ORACLE_HOME/rdbms/audit and the $ORACLE_BASE/admin/SID/adump directories.

We've put a script in place to clean these files out daily but is there a way to turn this feature off? Our system is generating thousands of these files a day!

I tried setting the parameter "audit_sys_operations" to FALSE and it didn't stop the system from generating these files. I even tried setting the "audit_file_dest" to /dev/null on a test RAC system (which I knew it wouldn't like ) and as suspected it wouldn't let me set it to that.

Grid (10g OEM) should be using the dbsnmp and NOT sys for metric collection.

I just dug a little deeper and found a custom script that connects every minute as sysdba about 10 times for EVERY database we have on each box. I talked to the other DBA that wrote it and he's going to change it to system instead.

Thanks for the answers guys, I still wish there was a way to turn this off.