Audit and database performance

  • From: ora_forum <ora_forum@xxxxxxxxx>
  • To: "Oracle Freelists.org" <Oracle-L@xxxxxxxxxxxxx>
  • Date: Thu, 11 Jan 2007 07:35:50 -0800 (PST)

Hi All,
   
  We have an application where we would like to setup audit on 30 tables to 
catch failed inserts. Should I expect application performance problem doing it 
for 30 tables? What is the overhead of doing:
   
  AUDIT  INSERT ON table_name BY ACCESS WHENEVER NOT SUCCESSFUL;
   
  Thanks.
  George.

 
---------------------------------
Have a burning question? Go to Yahoo! Answers and get answers from real people 
who know.

Other related posts: