START_PROFILER starts the profiler.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Syntax
DBMS_PROFILER.START_PROFILER(
run_comment IN VARCHAR2 := sysdate,
run_comment1 IN VARCHAR2 :='',
run_number OUT BINARY_INTEGER)
RETURN BINARY_INTEGER;
Parameters
| Parameter | Description |
|---|---|
| run_comment | The comment associated with the profiler during running. For example, the comment can provide the name and version of the benchmark used for collecting data. |
| run_comment1 | Allows you to comment on the running of the profiler. |
| run_number | The run number, which helps you store and call run data later. |
Examples
Run the following command to start the profiler:
obclient> call DBMS_PROFILER.start_profiler(run_comment => 'do_something: ' || SYSDATE);
Query OK, 0 rows affected (0.916 sec)