Auditing

Q: How to find the last time a table is queried in Oracle

Question:
I want to get the information about when a table is queried in oracle. Is there any log in oracle which shows the queries. I was looking around v$sqlarea and v$sqltext but, the system admin does not allow me to reach those tables. - Dursan @ Stack Overflow

My answer:

Need to audit changes? Can't change source database at all? This may work...

If you want to record copies of changed records on a target system you can do this with Golden Gate Software and not incur much in the way of source side resource drain.

Subscribe to Auditing