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