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

    dml happened on a table

    951290
      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 10.2.0.4.
      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 ?

      Regards
      Mahi