The ROLLUP_RUN procedure calculates the execution duration of each unit during an execution.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Syntax
PROCEDURE ROLLUP_RUN(run_number IN number);
Parameters
| Parameter | Description |
|---|---|
| run_number | The run number, which helps you store and call run data later. The IN value behind run_number is sourced from the run_number OUT parameter of start_profiler. |
Examples
obclient> call dbms_profiler.rollup_run(1);
Query OK, 0 rows affected (0.06 sec)
