查询
SQL> select * from dba_tab_modifications where TABLE_name like 'TEST%';
注意,你必须通过dbms_stats.flush_database_monitoring_info;才能刷新刚才的视图
You need to execute dbms_stats.flush_database_monitoring_info in order to get these views populated.
The timestamp column indicates the last time when the table was modified after the last gather statistics.
查看了一下官方的说明,转载过来给各位瞅瞅
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 provides such information for all tables in the database.
-
USER_TAB_MODIFICATIONS provides 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 DIMS_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
TABLE_OWNER | VARCHAR2(30) | Owner of the modified table. | |
TABLE_NAME | VARCHAR2(30) | Name of the modified table | |
PARTITION_NAME | VARCHAR2(30) | Name of the modified partition | |
SUBPARTITION_NAME | VARCHAR2(30) | Name of the modified subpartition | |
INSERTS | NUMBER | Approximate number of inserts since the last time statistics were gathered | |
UPDATES | NUMBER | Approximate number of updates since the last time statistics were gathered | |
DELETES | NUMBER | Approximate number of deletes since the last time statistics were gathered | |
TIMESTAMP | DATE | Indicates the last time the table was modified | |
DROP_SEGMENTS | NUMBER | Number of partition and subpartition segments dropped since the last analyze |