Auditing
Q: How to find the last time a table is queried in Oracle
dmann — Fri, 10/07/2011 - 10:45
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 OverflowMy answer:
Need to audit changes? Can't change source database at all? This may work...
dmann — Mon, 04/12/2010 - 11:42
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.
