Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Lots of Oracle10g Audit Log Files, Created every one or two second(s)
This is Oracle10g RAC, and there are lots of audit log files created
by default under $ORACLE_HOME/rdbms/audit folder, they got created
every one or two second(s) on each node, for each database instance
running on this RAC.
The following is one entry. As you can see, it does not have "CLIENT TERMINAL" information, and I don't know how to track this to find out which processes or application or background process is causing this sys login, so frequently.
Any ideas?
Thanks,
Hai
Audit file /home/oracle/app/product/10.1.0.4/rdbms/audit/ora_17242.aud
Oracle Database 10g Enterprise Edition Release 10.1.0.4.2 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining
options
ORACLE_HOME = /home/oracle/app/product/10.1.0.4
System name: Linux
Node name: wpprddb1 Release: 2.4.21-37.ELsmp Version: #1 SMP Wed Sep 7 13:28:55 EDT 2005 Machine: i686
Fri Apr 13 17:25:06 2007
ACTION : 'CONNECT'
DATABASE USER: '/'
PRIVILEGE : SYSDBA
CLIENT USER: oracle
CLIENT TERMINAL:
STATUS: 0
Received on Fri Apr 13 2007 - 17:28:30 CDT