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-compatible 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)