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 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. |