Does oracle (11g at least, but it would be nice if 10g too) have some statistics on DML been performed?
What I expect to get is: for table A in schema B it was performed I inserts, J updates, K deletes from date1 to date2
You can use the monitoring feature and the dba_tab_modifications table to get that information. See for example here or here.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With