This discussion is archived
3 Replies Latest reply: Oct 10, 2012 10:32 PM by SanjayPatel RSS

enable auditting for users

proora Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points