Hello, we have recently moved to Oracle from SQL Server and I am a newbie at a lot of Oracle standards. We turned on the oracle auditing features which I think are really robust however, I'm wondering what do people in the real world do with auditing? Do you audit EVERYTHING or do you only turn on certain things... do you write your own auditing logic... should we create separate tables to only store certain auditing fields?
We turned it on and of course its a TON of data... I assume we should prune it at some point? What interval do you recommend?
We have a process that takes 4 hours to run and without auditing it takes 3.5 hours to run. So, the auditing didn't seem to impact it all that much.
Any advice in the right direction is appreciated.