8 Replies Latest reply on Mar 28, 2013 12:27 PM by 951290

    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 ?