The DBMS_XPLAN package provides features for the management of logical plans, such as optimizing and tracing logical plans.
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 |
|---|---|
| DISABLE_OPT_TRACE | Disables the end-to-end tracing of the optimizer for the current session. |
| ENABLE_OPT_TRACE | Enables the end-to-end tracing of the optimizer for the current session. |
| SET_OPT_TRACE_PARAMETER | Sets the end-to-end tracing parameters of the optimizer for the current session. |