Home Oracle Commands Oracle Data Dictionary
v$ Performance views

DBA_TAB_MODIFICATIONS

Information regarding modifications to tables

Columns
   ___________________________
 
   TABLE_OWNER
      Owner of modified table
   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:

 DBA_ALL_TABLES         ALL_ALL_TABLES        USER_ALL_TABLES
 DBA_PART_TABLES        ALL_PART_TABLES       USER_PART_TABLES 
 DBA_TABLES             ALL_TABLES            USER_TABLES          TAB 
 DBA_TAB_COLUMNS        ALL_TAB_COLUMNS       USER_TAB_COLUMNS 
 DBA_TAB_COLS           ALL_TAB_COLS          USER_TAB_COLS 
 DBA_TAB_COL_STATISTICS ALL_TAB_COL_STATISTICS USER_TAB_COL_STATISTICS 
 DBA_TAB_COMMENTS       ALL_TAB_COMMENTS      USER_TAB_COMMENTS 
 DBA_TAB_HISTOGRAMS     ALL_TAB_HISTOGRAMS    USER_TAB_HISTOGRAMS 
 DBA_TAB_MODIFICATIONS  ALL_TAB_MODIFICATIONS USER_TAB_MODIFICATIONS 
 DBA_TAB_PARTITIONS     ALL_TAB_PARTITIONS    USER_TAB_PARTITIONS 



Simon Sheppard
SS64.com