The DBMS_PLAN_CACHE package is dedicated for OceanBase Database. It is used for fine-grained operations on the SQL plan cache.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL-compatible mode.
Privileges
This package must be created under the SYS user. To use this package, you must have the EXECUTE privilege on SYS.DBMS_PLAN_CACHE.
Subprograms
The following table describes the DBMS_PLAN_CACHE subprograms supported by the current OceanBase Database version.
| Subprogram | Description |
|---|---|
| PURGE | Removes a specified SQL statement from the plan cache. |