DBA Table Modifications

Description

Categories
Enginatics
Repository
GitHub
If table monitoring is activated, dba_tab_modifications shows the number of rows modified since the last time a table was analyzed.

SQL 29 lines

Parameters 2

ParameterTypeList of values SQL
Changes per Day FromNumber
dtm.total_changes/(sysdate-dt.last_analyzed)>:changes_per_day_from
Last Analyzed within x DaysNumber
dt.last_analyzed>sysdate-:analyzed_days