5 Replies Latest reply: Apr 25, 2014 7:52 AM by EdStevens RSS

    oracle 11g audit

    1003614

      Hi All,

       

      oracle 11g (11.2.0.1)

      linux

       

      while checking audit trail option am getting below output...is it mean audit is enable at database level?

       

      SQL> show parameter audit

      NAME                                 TYPE        VALUE

      ------------------------------------ ----------- ------------------------------

      audit_file_dest                      string      /tmp/adump

      audit_sys_operations                 boolean     TRUE

      audit_syslog_level                   string

      audit_trail                          string      DB

      SQL>

      SQL>

       

      and how to check how many days audit data available in the audit trail repository?

       

      thanks,

      Mike.