The DBMS_XPROFILE system 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 privilege to execute PL/SQL can use this feature.
Overview of DBMS_XPROFILE subprograms
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 performance analysis data for the SQL execution plan and provides operator-level diagnostic information for the specified trace_id. |