The DBMS_XPLAN system package provides features related to logical plan management, including logical plan optimization tracing.
Applicability
This content applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL-compatible mode.
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. |