FLUSH_DATABASE_MONITORING_INFO

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.

Usage notes

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

CALL DBMS_STATS.FLUSH_DATABASE_MONITORING_INFO;
Query OK, 0 rows affected