3 Replies Latest reply: Oct 11, 2012 12:32 AM by SanjayPatel RSS

    enable auditting for users

    proora
      Hello World ,

      i enable auditing on the database 10.2 for users,

      once i query SQL> SELECT username,
      extended_timestamp,
      owner,
      obj_name,
      action_name
      FROM dba_audit_trail
      WHERE owner = <Username>

      there are many many rows , my question is , are you enable to truncate it from time to time , if not ,is it effect on the performance of the database ?


      thanks