SQL> execute dbms_stats.flush_database_monitoring_info;
SQL> select table_owner,table_name,inserts,updates,deletes from dba_tab_modifications where table_name='TEST';
TABLE_OWNER TABLE_NAME INSERTS
------------------------------ ------------------------------ ----------
UPDATES DELETES
---------- ----------
ANURAG TEST 1
0 0
SQL> execute dbms_stats.flush_database_monitoring_info;
PL/SQL procedure successfully completed.
SQL> select table_owner,table_name,inserts,updates,deletes from dba_tab_modifications where table_name='TEST';
TABLE_OWNER TABLE_NAME INSERTS
------------------------------ ------------------------------ ----------
UPDATES DELETES
---------- ----------
ANURAG TEST 2
0 0
Thank you, Anurag
ReplyDelete