Table: USER_TAB_MODIFICATIONS
Information regarding modifications to tables
| Column Name | Description |
|---|---|
| DELETES | Approximate number of rows deleted since last analyze |
| DROP_SEGMENTS | Number of (sub)partition segment dropped since the last analyze? |
| INSERTS | Approximate number of rows inserted since last analyze |
| PARTITION_NAME | Modified partition |
| SUBPARTITION_NAME | Modified subpartition |
| TABLE_NAME | Modified table |
| TIMESTAMP | Timestamp of last time this row was modified |
| TRUNCATED | Was this object truncated since the last analyze? |
| UPDATES | Approximate number of rows updated since last analyze |