The DBMS_XPLAN package provides logical plan management features, such as logical plan optimization and tracing.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Privileges
To call the DBMS_XPLAN package, you must have the PL SQL execution privilege.
Subprograms
The following table describes the DBMS_XPLAN subprograms supported by the current OceanBase Database version.
| Subprogram | Description |
|---|---|
| DISABLE_OPT_TRACE | Disables end-to-end tracing for the optimizer of the current session. |
| ENABLE_OPT_TRACE | Enables end-to-end tracing for the optimizer of the current session. |
| SET_OPT_TRACE_PARAMETER | Modifies end-to-end tracing parameters for the optimizer of the current session. |