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 the TABLE_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. For performance reasons, the Oracle Database does not populate these views immediately when the actual modifications occur. Run the FLUSH_DATABASE_MONITORING_INFO
procedure in the DBMS_STATS
PL/SQL package to populate these views with the latest information. The ANALYZE_ANY
system privilege is required to run this procedure.
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:
Oracle Database PL/SQL Packages and Types Reference for more information about the DBMS_STATS.FLUSH_DATABASE_MONITORING_INFO
procedure