| auditing [message #521620] |
Wed, 31 August 2011 10:39  |
matthew00
Messages: 7
Registered: October 2005
|
Junior Member |
|
|
on my DB, I had audit_trial=DB and I didn't have anything set up for audit such as log on, insert, delete etc........
However, I do see records in SYS.AUD$ and I wonder if it will have performance impact even if I don't have anything set up for audit.
thx
|
|
|
|
| Re: auditing [message #521624 is a reply to message #521620] |
Wed, 31 August 2011 10:48  |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
>I wonder if it will have performance impact even if I don't have anything set up for audit.
yes, no, maybe, it depends.
Can you get something for nothing?
If you can't measure something, does it really exist?
What can you do to change existing DB behavior regarding SYS.AUD$?
[Updated on: Wed, 31 August 2011 10:48] Report message to a moderator |
|
|
|
|
|
|
|
|
|
| Re: auditing [message #521686 is a reply to message #521634] |
Thu, 01 September 2011 01:16 |
 |
Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Actually when at any point in time you previously audited something "by session" (in the opposite to "by access") then Oracle afterwards adds a record of type 103 for each session even if nothing is now audited.
You have to switch off auditing with audit_trail=none or off (and restart the db) to clear this behaviour.
Regards
Michel
[Updated on: Thu, 01 September 2011 01:16] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
