The DBMS_XPLAN package provides features for managing logical plans, including logical plan optimization tracking.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support this feature.
Privilege requirements for DBMS_XPLAN
Users with the execute privilege on PL/SQL can use this feature.
Subprograms of DBMS_XPLAN
The following table lists the DBMS_XPLAN subprograms supported in the current version of OceanBase Database and their brief descriptions.
Subprogram |
Description |
|---|---|
| DISPLAY_ACTIVE_SESSION_PLAN | Displays the real-time plan details of the specified session. |
| DISPLAY_CURSOR | Displays the details of the executed query plan. |
| DISPLAY | Queries and formats the historical EXPLAIN plans. |
| DISABLE_OPT_TRACE | Disables the optimizer full-trace feature for the current session. |
| DISPLAY_SQL_PLAN_BASELINE | Views the baseline plans of the SQL Plan Management (SPM) feature. |
| ENABLE_OPT_TRACE | Enables the optimizer full-trace feature for the current session. |
| SET_OPT_TRACE_PARAMETER | Modifies the parameters of the optimizer full-trace feature for the current session. |