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.
FLUSH_DATABASE_MONITORING_INFO will immediately update related information in the *_TAB_STATISTICS and *_IND_STATISTICS views with no need to wait for periodic database updates. 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