8 Replies Latest reply: Mar 28, 2013 7:27 AM by 951290 RSS

    dml happened on a table

      hi gurus,

      i have a doubt , please clear me,

      Is there is any view to find the last dml happened on a a particular table?? i am working in oracle version
      i don't want to use any trigger or auditing features.

      what is the use of DBA_HIST_ACTIVE_SESS_HISTORY and DBA_HIST_SQLTEXT ?

      how can i use effectively ?