3 Replies Latest reply: May 17, 2012 4:49 AM by Karan RSS

    Block growth sys.aud$ table permanently

    Fazlul Kabir Mahfuz
      Database version 11gr2. Database audit parameter is below

      NAME                                        TYPE          VALUE
      ------------------------------------ ----------- ------------------------------
      audit_file_dest                              string          /u01/app/oracle/admin/DATAWH/adump
      audit_sys_operations                    boolean          FALSE
      audit_syslog_level                         string
      audit_trail                                   string          DB

      Actually this above value is default value. We don’t use auditing in this database. Everyday sys.aud$ table is increaseing and we truncate every week. Is there any option to block growth permanently?