The FLUSH_DATABASE_MONITORING_INFO procedure updates the memory monitoring information of all tables in the dictionary.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Syntax
DBMS_STATS.FLUSH_DATABASE_MONITORING_INFO;
Exceptions
The error code ORA-20000 indicates that you do not have the required privileges.
Considerations
To call this procedure, you must have the ANALYZE ANY privilege.
The FLUSH_DATABASE_MONITORING_INFO procedure will immediately update corresponding information in the *_TAB_STATISTICS and *_IND_STATISTICS views without waiting for periodical updates of the database. The GATHER_*_STATS procedure refreshes the monitoring information internally and therefore does not need to be called before statistics are collected.
Examples
obclient> CALL DBMS_STATS.FLUSH_DATABASE_MONITORING_INFO;
Query OK, 0 rows affected
