ba6.us - Dave's Database Related Stuff

  • home
  • blog
  • notebooks
  • projects
  • recent
  • about
  • manifesto
  • !
Home

Tag Cloud

apex Application Express Auditing data dbi development export funnies HTML Java linux monitoring oem oracle performance perl rman scripting sql SQL Developer sqlplus tuning unix windows
more tags

Search

RSS Feed

Blog Posts :

Navigation

  • Feed aggregator

User login

  • Request new password

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 Overflow

My answer:

Read more »
  • Auditing
  • question
  • dmann's blog
  • Add new comment

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.
Read more »
  • Auditing
  • Golden Gate
  • dmann's blog
  • Add new comment
Syndicate content


Cornify
  • home
  • blog
  • notebooks
  • projects
  • recent
  • about
  • manifesto
  • !

Content Copyright 2006-2010. Links are copyright of respective owners.