I am currently tasked with developing a action plan for monitoring DB activity, encompassing general actions (failed logons etc) with some finer grained monitoring(e.g. who selected from table x, what was the SQL statement etc)
During the course of investigating what could be done, simply turning on and tuning Oracle DB auditing seemed to hit most (if not all) of the requirements, albeit with the caveat that performance would need to be considered carefully)
But ideally I would like to go back with a few proposals to discuss, my other thoughts would be to produce triggers for the tables and send them off to some other 'Audit' schema but this smacks of re-inventing the wheel.
So I was wondering if anyone had any experience around this area and could point in the direction of further reading/suggestions for any other viable alternatives