find out what time a record was created/modified
435170Dec 23 2004 — edited Dec 23 2004To the point: Is there an easy way to determine when a record was created/modified?
Background: I would like to analyze some of the performance of our web app by querying the database's history during off-peak hours. Some important/frequent/expensive operations in our web app require a significant chunk of the web app's processing power as well as quite a few database transactions. So for a given application operation, I'd like to look at all the records related to it in the database and see when each one was touched to determine min, max, and avg times for the given operation.
We've just converted to Oracle, so I'm brand new to PL/SQL, but I promise to try to learn fast! I'd just like some pointers in the right direction...