Database Administration (MOSC)

MOSC Banner

Can I use the "v$dml_stats" to monitor some table's dml operations or data growth in real time?

edited Nov 26, 2024 8:28AM in Database Administration (MOSC) 5 commentsAnswered ✓

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center