Performance issues with auditing on all tables

Lindsey6
Giga Contributor

‎07-13-2018 10:24 AM

Good afternoon, 

Does anyone know if there would be performance issues by having auditing enabled on all tables? (Jakarta version). Is it best practice to only have certain tables enabled for auditing and if so, do you know which ones they would be?

Any recommendations/suggestions would be appreciated. 

Thank you, 

Lindsey

0 Helpfuls
  • 1,411 Views
1 REPLY 1

sachin_namjoshi
Kilo Patron
Kilo Patron

‎07-13-2018 10:29 AM

Turning on audit depends on your requirements.

IF you want to track field updates( old and new values) on table, then you turn on audit for your custom table.

It's not good idea to turn on audit for all your instance tables since this will cause your sys_audit, sys_history_line size to increase in short span of time.This will impact instance performance in long run even if these tables are rotated OOB.

 

Regards,

Saachin