Can I use the "v$dml_stats" to monitor some table's dml operations or data growth in real time?
HI,
I have a requirement to monitor the DML operations or data growth of some tables in the database,I want to use dba_tab_modifications for monitoring, but some articles said that dba_tab_modifications updated only one time in 24h.When I analyze the execution plan of the query statement for this view, I found the v$dml_stat, it also have dml rows record and seems like refresh real time. If I query it each minute or each ten minutes, will it affect the performance of the database? Because I found this view queries X$KSXMME.
Thanks.