3.110 ALL_TAB_MODIFICATIONS
ALL_TAB_MODIFICATIONS
describes tables accessible to the current user that have been modified since the last time statistics were gathered on the tables.
Related Views
-
DBA_TAB_MODIFICATIONS
describes such information for all tables in the database. -
USER_TAB_MODIFICATIONS
describes such information for tables owned by the current user. This view does not display theTABLE_OWNER
column.
Note:
These views are populated only for tables with the MONITORING
attribute. They are intended for statistics collection over a long period of time.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the modified table |
|
|
|
Name of the modified table |
|
|
|
Name of the modified partition |
|
|
|
Name of the modified subpartition |
|
|
|
Approximate number of inserts since the last time statistics were gathered |
|
|
|
Approximate number of updates since the last time statistics were gathered |
|
|
|
Approximate number of deletes since the last time statistics were gathered |
|
|
|
Indicates the last time the table was modified |
|
|
|
Indicates whether the table has been truncated since the last analyze ( |
|
|
|
Number of partition and subpartition segments dropped since the last analyze |
See Also: