user_tab_modifications

注意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
请使用浏览器的分享功能分享到微信等