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博客 ” ，链接：https://blog.itpub.net/27573546/viewspace-759937/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
