The DBMS_XPROFILE package is a performance analysis tool used to deeply analyze resource consumption and operator-level performance metrics during SQL execution.
Privilege requirements for DBMS_XPROFILE
Users with the execute PL/SQL privilege can use this feature.
Subprograms of DBMS_XPROFILE
The following table lists the DBMS_XPROFILE subprograms supported in the current version of OceanBase Database and their brief descriptions.
| Subprogram | Description |
|---|---|
| DISPLAY_PROFILE | Displays the performance analysis data of the SQL execution plan and allows viewing the operator-level diagnostic information for the specified trace_id. |