The DBMS_XPLAN system package provides features related to logical plan management, including logical plan optimization tracing.
DBMS_XPLAN Privilege Description
Users with the privilege to execute PL/SQL can use this feature.
Overview of DBMS_XPLAN Subprograms
The following table lists the DBMS_XPLAN subprograms supported by the current version of OceanBase Database and provides brief descriptions.
subprogram |
Description |
|---|---|
| DISPLAY_ACTIVE_SESSION_PLAN | Displays the real-time plan details of a specified session. |
| DISPLAY_CURSOR | Displays details of executed query plans. |
| DISPLAY | Query and format historicalEXPLAINPlan. |
| DISABLE_OPT_TRACE | Disables end-to-end tracing for the optimizer of the current session. |
| DISPLAY_SQL_PLAN_BASELINE | View the baseline plan of SPM. |
| ENABLE_OPT_TRACE | Enable end-to-end tracing for the optimizer of the current session. |
| SET_OPT_TRACE_PARAMETER | Modifies the end-to-end tracing parameters of the optimizer for the current session. |