We have an audit requirement to know about all code changes that go into our production environment. At the moment this done by the rather cumbersome method of taking a copy of the all_source view each day. We then run a PL/SQL package to compare todays all_source with the stored copy from the previous day, looking for inserted, deleted or updated rows of data and then reporting at object_name level. This allows us to catch unplanned changes as well as planned changes in production.
Whilst this works its not good and can take a long time to run, is there a better way of doing this perhaps using triggers or some form of notification?