Audit files [message #333647] |
Mon, 14 July 2008 01:06 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ora_2007
Messages: 430 Registered: July 2007 Location: Mumbai
|
Senior Member |
|
|
I have so many ora_*****.aud files in the /adump folder.
Does oracle by default generates .aud files?
1. I think this is normal behaviour of the oracle to generate .aud files, am i right?
Please tell me does oracle generates file for every sys connection?
Sample file.
Audit file /home/oracle/admin/ora01/adump/ora_24340.aud
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning and Data Mining options
ORACLE_HOME = /home/oracle/product/10gR2
System name: Linux
Node name:
Release: 2.6.5-7.97-smp
Version: #1 SMP Fri Jul 2 14:21:59 UTC 2004
Machine: i686
Instance name: oracleora
Redo thread mounted by this instance: 1
Oracle process number: 27
Unix process pid: 24340, image: oracle@TEST1
Mon Jul 14 01:00:03 2008
ACTION : 'CONNECT'
DATABASE USER: '/'
PRIVILEGE : SYSDBA
CLIENT USER: oracle
CLIENT TERMINAL:
STATUS: 0
2. Should i delete old files from the database? I think there will no problem if i delete the old files, am i right?
[Updated on: Mon, 14 July 2008 01:07] Report message to a moderator
|
|
|
|
|