Re: Question Auditing Session = Logons (inspired by Stephen's email)

From: Tanel Poder <tanel_at_tanelpoder.com>
Date: Thu, 28 Feb 2013 01:01:18 +0200
Message-ID: <CAMHX9JKT0itmkWSdofX94SDUi5Cx-4n4hnmXvFQzziUEmWYrpA_at_mail.gmail.com>



Are you auditing into the OS files then? (not to AUD$?) Logins via SYSDBA/SYSOPER will always generate an .aud file, no way around it.

And in 11.1 there's a bug 9744092: EXCESSIVE AMOUNT OF AUD FILES BEING GENERATED IN 11.1 - which causes even regular (non-sysdba) application logins create audit files.

-- 
*Tanel Poder*
Enkitec (The Exadata Experts)
Training <http://blog.tanelpoder.com/seminar/> |
Troubleshooting<http://blog.tanelpoder.com/>
 | Exadata<http://www.amazon.com/Expert-Oracle-Exadata-Apress/dp/1430233923>
 | Voicee App <http://voic.ee/>



On Wed, Feb 27, 2013 at 9:14 PM, <Christopher.Taylor2_at_parallon.net> wrote:


> Can you audit the other things without auditing SESSION (Logons) ?
> We have a scenario where we're generating thousands of .aud files per day
> - and our user population is not very large.
>
> I've just started investigating this and want to reduce the number of aud
> files generated.
>
> We have some applications that all they do is connect to the database and
> disconnect to verify it is up. And they do this several times a minute
> from different servers; an issue which is on "the list" to be addressed.
>
>
>
> Chris Taylor
> Oracle DBA
> Parallon IT&S
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- http://www.freelists.org/webpage/oracle-l
Received on Thu Feb 28 2013 - 00:01:18 CET

Original text of this message