The FLUSH_DATABASE_MONITORING_INFO procedure is used to refresh the in-memory monitoring information for all tables in the dictionary.
Syntax
DBMS_STATS.FLUSH_DATABASE_MONITORING_INFO;
Exceptions
The error code HY000 indicates insufficient privileges.
Considerations
FLUSH_DATABASE_MONITORING_INFO immediately updates the corresponding information in the *_TAB_STATISTICS and *_IND_STATISTICS views without waiting for the regular database refresh. The GATHER_*_STATS procedure internally refreshes the monitoring information, so you do not need to run this stored procedure before collecting statistics.
Examples
obclient> CALL DBMS_STATS.FLUSH_DATABASE_MONITORING_INFO;
Query OK, 0 rows affected