Database Administration (MOSC)

MOSC Banner

usage of DBMS_STATS.FLUSH_DATABASE_MONITORING_INFO()

edited Mar 20, 2018 10:29AM in Database Administration (MOSC) 7 commentsAnswered

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

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