The FLUSH_DATA procedure flushes the collected data to the data statistical table.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Syntax
DBMS_PROFILER.FLUSH_DATA
RETURN BINARY_INTEGER;
DBMS_PROFILER.FLUSH_DATA;
Note
RETURN BINARY_INTEGER specifies to return a binary integer. In actual scenarios, you do not need to declare RETURN BINARY_INTEGER separately but can directly call the FLUSH_DATA procedure.
Examples
obclient> call DBMS_PROFILER.flush_data();
Query OK, 0 rows affected (0.012 sec)