The DBMS_SPM package is used for managing SQL plans. It supports operations such as loading, modifying, and dropping plan baseline information.
Subprogram overview
The following table lists the subprograms of the DBMS_SPM package supported in the current version of OceanBase Database and their descriptions.
| Subprogram | Description |
|---|---|
| ACCEPT_SQL_PLAN_BASELINE | Accepts a plan as a baseline based on the evolution results. |
| ALTER_SQL_PLAN_BASELINE | Modifies the attributes of one or more plans in a baseline. The return value indicates the number of modified baselines. |
| CANCEL_EVOLVE_TASK | Cancels an ongoing evolution task. |
| CONFIGURE | Sets some parameters of SPM. |
| DROP_EVOLVE_TASK | Drops an evolution task. |
| DROP_SQL_PLAN_BASELINE | Drops one or more plan baselines. |
| LOAD_PLANS_FROM_CURSOR_CACH | Reads one or more SQL plans from the Cursor Cache as a plan baseline. |