DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2006

    AUDIT ALL BY <user>

    I am looking to enable auding on my 10g(soon to be converted to 11gr2)
    system and have a few questions.

    Ie AUDIT ALL by

    I am going to set audit_trail=xml, which means that files will be created on
    the file system. I know the default location of audit files is $ORACLE_HOME/rdbms/aduit to over-ride that location I can I set audit_file_dest=''

    Secondly, does Oracle provide a tool or cleanup process for the .xml
    files that will be generated or is this something I need to create a script for?

    Ie; when using adrci I know I can use the purge command to remove
    incidents, cores, ..... does Oracle have something like this for removal
    of audit files.

  2. #2
    Join Date
    Mar 2007
    Ft. Lauderdale, FL
    As far as I know there is not automatic purging on audit records - not even for AUD$ table therefore I would plan on doing it via a custom script.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.