The DBMS_SPM package is used to manage SQL plans, including loading, modifying, and dropping plan baseline information.
Subprogram overview
The following table describes the DBMS_SPM subprograms supported by OceanBase Database in the current version.
| Subprogram | Description |
|---|---|
| ACCEPT_SQL_PLAN_BASELINE | Accepts a plan as a baseline based on the evolution plan. |
| 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. |