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