Hello,


My goal is to produce a list of all objects (procedures, packages, functions, triggers, and tables) that have changed in the database since they were first created.


I have a query that compares "created" and last_ddl_time" in the view "dba_objects". I am only showing those objects where those two time stamps are not equal.


I thought this was a good solution; however, many of my "last_ddl_time" values are only 1 second later than the "created" values. I am not really sure how that happens as our developers are not that quick in making changes :-)


So my next thought was to check for the user who last updated/compiled each object. I do not see a column in "dba_objects" that tracks a user ID.


Is there another view I should be using for this?


Or is there another approach altogether I should be using to achieve my goal?


Thanks in advance!


Dennis