The STOP_PROFILER procedure 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.
Exceptions
The return value 0 indicates success, 1 indicates a parameter error, 2 indicates an I/O error, and -1 indicates a DBMS_PROFILER version error.
Examples
Execute the following statement to stop the profiler:
obclient> call DBMS_PROFILER.stop_profiler();
Query OK, 0 rows affected (1.238 sec)