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.
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 |
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/27573546/viewspace-759937/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/27573546/viewspace-759937/