STOP_PROFILER stops the profiler.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Syntax
DBMS_PROFILER.STOP_PROFILER
RETURN BINARY_INTEGER;
DBMS_PROFILER.STOP_PROFILER;
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 STOP_PROFILER procedure.
Examples
Run the following command to stop the profiler:
obclient> call DBMS_PROFILER.stop_profiler();
Query OK, 0 rows affected (1.238 sec)