Oracle® Database Reference 11g Release 2 (11.2) Part Number E17110-08 |
|
|
PDF · Mobi · ePub |
DBA_TAB_MODIFICATIONS
describes modifications to all tables in the database that have been modified since the last time statistics were gathered on the tables. Its columns are the same as those in "ALL_TAB_MODIFICATIONS".
Note:
This view is populated only for tables with theMONITORING
attribute. It is intended for statistics collection over a long period of time. For performance reasons, the Oracle Database does not populate this view immediately when the actual modifications occur. Run the FLUSH_DATABASE_MONITORING_INFO
procedure in the DBMS_STATS
PL/SQL package to populate this view with the latest information. The ANALYZE_ANY
system privilege is required to run this procedure.