R
Rob Fitzpatrick
Guest
OE Auditing was added in 10.1A. While it doesn't require application changes per se, making code changes can enable richer audit data like application context, if that's interesting to you. If you use auditing I recommend you add an audit archive database and regularly transfer your production audit data to it (via auditarchive/audit load) for querying and reporting. There are other best practices I haven't mentioned that you should research before implementing auditing. What is the use case for adding the update time stamp? Do you need it on all tables or just a subset?
Continue reading...
Continue reading...