usage of DBMS_STATS.FLUSH_DATABASE_MONITORING_INFO()
Database Version: 11.2.0.2
Hardware: EXADATA
We need to trend our
Production data with highly volatile tables which are having frequent DML
operations. We are trying to select DBA_TAB_MODIFICATIONS table in frequent
intervals to check the number of INSERT, UPDATE and DELETE operations. But the
data is not updating in DBA_TAB_MODIFICATION table since LAST STATISTICS
gathered. Alternatively if we can run
DBMS_STATS.FLUSH_DATABASE_MONITORING_INFO() will be flushed the data from
memory to DBA_TAB_MODIFICATIONS and we can get current information. But, we
have following questions outstanding : -
1) Is there any
configuration that we can flush DML data in a regular intervals into