Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

DML statistics, oracle

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

like image 627
zerkms Avatar asked Jul 13 '26 09:07

zerkms


1 Answers

You can use the monitoring feature and the dba_tab_modifications table to get that information. See for example here or here.

like image 143
Mat Avatar answered Jul 16 '26 00:07

Mat