The ROLLUP_UNIT procedure calculates the execution duration of a specific 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_UNIT(run_number IN number,unit 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. |
| unit | The object ID, corresponding to the unit_number column in the data statistical table. |
Examples
obclient> call dbms_profiler.rollup_unit(1,501810);
Query OK, 0 rows affected (0.08 sec)