Home Oracle Commands Oracle Data Dictionary
v$ Performance views

USER_TAB_MODIFICATIONS

Information regarding modifications to tables

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

Related Commands:




Back to the Top

Simon Sheppard
SS64.com