The DBMS_XPLAN package provides features for the management of logical plans, such as optimizing and tracing logical plans.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Privileges
To use the package, you must have the privileges to execute PL SQL statements.
Subprograms
The following table describes the DBMS_XPLAN subprograms supported by the current OceanBase Database version.
| Subprogram | Description |
|---|---|
| DISPLAY_ACTIVE_SESSION_PLAN | Displays the details of the active execution plan in the specified session. |
| DISPLAY_CURSOR | Displays the details of an executed query plan. |
| DISPLAY | Displays the execution plan generated for an SQL statement after the statement is explained by EXPLAIN. |
| DISABLE_OPT_TRACE | Disables end-to-end tracing for the optimizer of the current session. |
| DISPLAY_SQL_PLAN_BASELINE | Displays a baseline plan in SQL Plan Management (SPM). |
| ENABLE_OPT_TRACE | Enables end-to-end tracing for the optimizer of the current session. |
| SET_OPT_TRACE_PARAMETER | Sets end-to-end tracing parameters for the optimizer of the current session. |
