Hello Tom.
I set audit trail to "XML,EXTENDED" , because my $AUD table was growing to much.
I have a lot of 4kb files generated. I have several scripts in my crontab, and that is what is being audited.
The content of the files are like this:
Audit file /o2/audit_trail/BASE_ora_5110_2.aud
Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
ORACLE_HOME = /o/app/oracle/product/11.2.0/db_seo
System name: Linux
Node name: oracleDB
Release: 3.8.13-118.2.5.el6uek.x86_64
Version: #2 SMP Tue Jan 19 15:43:24 PST 2016
Machine: x86_64
VM name: VMWare Version: 6
Instance name: BASE
Redo thread mounted by this instance: 1
Oracle process number: 85
Unix process pid: 5110, image: oracle@oracleDB (TNS V1-V3)
Fri Jan 12 08:25:01 2018 -03:00
LENGTH : '155'
ACTION :[7] 'CONNECT'
DATABASE USER:[1] '/'
PRIVILEGE :[6] 'SYSDBA'
CLIENT USER:[6] 'oracle'
CLIENT TERMINAL:[0] ''
STATUS:[1] '0'
DBID:[10] '*********'
After that, i set audit_trail to none, but still files are generated.
SQL> show parameter audit_trail;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_trail string NONE
My questions are :
1) Why are those file generated if audit_trail is NONE
2) How can I filter, in order to not auditing my own scripts.
Best,
Thank you in advanced.