Today I got to learn about this view in Oracle which stores all the inserts, updates and deletes done on a particular table. There are three views corresponding to it.
DBA_TAB_MODIFICATIONS
ALL_TAB_MODIFICATIONS
USER_TAB_MODIFICATIONS
All we need to in this case is to execute the below procedure to update these views with the information.
exec dbms_stats.flush_database_monitoring_info
This proc would populate the data into the views and we can easily tell the number of inserts, updates and deletes that happened on a particular table. I learned this primariy from this link. According to Martin's blog the data would not record insertes done by multiple table inserts. But would record all the other DML operations on the table.
No comments:
Post a Comment