Home Oracle Commands Oracle Data Dictionary
v$ Performance views

USER_TAB_MODIFICATIONS

Information regarding modifications to tables

Columns
   ___________________________
 
   TABLE_NAME
      Modified table
   PARTITION_NAME
      Modified partition
   SUBPARTITION_NAME
      Modified subpartition
   INSERTS
      Approximate number of rows inserted since last analyze
   UPDATES
      Approximate number of rows updated since last analyze
   DELETES
      Approximate number of rows deleted since last analyze
   TIMESTAMP
      Timestamp of last time this row was modified
   TRUNCATED
      Was this object truncated since the last analyze?

Related:



Simon Sheppard
SS64.com