FAQ
Dear list,

regardless of AUDIT_TRAIL and AUDIT_SYS_OPERATIONS both switched off, the
10g and especially the 11g databases are creating lots of .aud files in
adump directory. Oracle-l thread
http://www.freelists.org/post/oracle-l/Oracle-102-auditing,3 describes that
as well.

But how can I switch it off completely? I simply don't need it, and want to
avoid a periodic cleanup job or setting the dump directory to /dev/null. :)

Thanks in advance, and best regards
--
Mit freundlichem Gruß

Martin Klier
Senior Oracle Database Administrator

Klug GmbH integrierte Systeme
Lindenweg 13, D-92552 Teunz
Tel.: +49 9671/9216-245
Fax.: +49 9671/9216-112
mailto: martin.klier_at_klug-is.de
www.klug-is.de

Geschäftsführer: Johann Klug, Roman Sorgenfrei
Sitz der Gesellschaft: Teunz, USt-ID-Nr. DE175481608,
HRB Nr. 2037, Amtsgericht Amberg

--
http://www.freelists.org/webpage/oracle-l

Search Discussions

  • Karl Arao at Aug 12, 2009 at 10:16 am
    Hi Martin,

    I just have a clean up script for that :) then put it in cron..

    find /oracle/oraprod/proddb/10.2.0/admin/PROD/adump -name "*.aud"
    -mtime +7 -exec ls -l {} \; >
    ${HOME_DIR}/logs/trace_and_logs/${DB_NAME}-adump-$(date
    +%Y%m%d%H%M).log
    find /oracle/oraprod/proddb/10.2.0/admin/PROD/adump -name "*.aud"
    -mtime +7 -exec rm -rf {} \;

    Karl Arao
    http://karlarao.wordpress.com
    On Wed, Aug 12, 2009 at 3:03 PM, Martin Klier wrote:

    Dear list,

    regardless of AUDIT_TRAIL and AUDIT_SYS_OPERATIONS both switched off, the
    10g and especially the 11g databases are creating lots of .aud files in
    adump directory. Oracle-l thread
    http://www.freelists.org/post/oracle-l/Oracle-102-auditing,3 describes that
    as well.

    But how can I switch it off completely? I simply don't need it, and want to
    avoid a periodic cleanup job or setting the dump directory to /dev/null. :)

    Thanks in advance, and best regards
    --
    Mit freundlichem Gruß


    Martin Klier
    Senior Oracle Database Administrator
    ------------------------------------------------------------------------------

    Klug GmbH integrierte Systeme
    Lindenweg 13, D-92552 Teunz
    Tel.:  +49 9671/9216-245
    Fax.: +49 9671/9216-112
    mailto: martin.klier_at_klug-is.de
    www.klug-is.de
    ------------------------------------------------------------------------------

    Geschäftsführer: Johann Klug, Roman Sorgenfrei
    Sitz der Gesellschaft: Teunz, USt-ID-Nr. DE175481608,
    HRB Nr. 2037, Amtsgericht Amberg

    --
    http://www.freelists.org/webpage/oracle-l

    --
    http://www.freelists.org/webpage/oracle-l

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedAug 12, '09 at 7:03a
activeAug 12, '09 at 10:16a
posts2
users2
websiteoracle.com

2 users in discussion

Karl Arao: 1 post Martin Klier: 1 post

People

Translate

site design / logo © 2022 Grokbase