注意user_tab_modifications视图要先刷新一下，才能看到最新的
SQL> exec dbms_stats.flush_database_monitoring_info();
SQL> select TABLE_NAME,INSERTS,UPDATES,DELETES,TRUNCATED,TIMESTAMP,DROP_SEGMENTS from dba_tab_modifications where table_name in('INF_BILL_STOP_OPEN','INF_BILL_STOP_OPEN_C') and table_owner='IOM';
TABLE_NAME INSERTS UPDATES DELETES TRU TIMESTAMP DROP_SEGMENTS
------------------------------ ---------- ---------- ---------- --- ------------------- -------------
INF_BILL_STOP_OPEN 97462 99322 97736 NO 2017-09-18 20:20:36 0
INF_BILL_STOP_OPEN_C 149527816 74824399 149739299 NO 2017-09-18 20:20:36 0
SQL> exec dbms_stats.flush_database_monitoring_info();
SQL> select TABLE_NAME,INSERTS,UPDATES,DELETES,TRUNCATED,TIMESTAMP,DROP_SEGMENTS from dba_tab_modifications where table_name in('INF_BILL_STOP_OPEN','INF_BILL_STOP_OPEN_C') and table_owner='IOM';
TABLE_NAME INSERTS UPDATES DELETES TRU TIMESTAMP DROP_SEGMENTS
------------------------------ ---------- ---------- ---------- --- ------------------- -------------
INF_BILL_STOP_OPEN 97462 99322 97736 NO 2017-09-18 20:20:36 0
INF_BILL_STOP_OPEN_C 149527816 74824399 149739299 NO 2017-09-18 20:20:36 0
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/31397003/viewspace-2145126/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
