The DBMS_PLAN_CACHE system package is specific to OceanBase Database and provides fine-grained operations for the SQL execution plan cache (Plan Cache).
Applicability
This content applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL-compatible mode.
DBMS_PLAN_CACHE Privilege Description
This system package must be created under SYS. To use this system package, you must have the EXECUTE privilege on SYS.DBMS_PLAN_CACHE.
Overview of the DBMS_PLAN_CACHE Subprogram
The following table lists the DBMS_PLAN_CACHE subprograms supported by the current version of OceanBase Database and provides brief descriptions.
Subprogram |
Description |
|---|---|
| PURGE | Removes the specified SQL from the plan cache. |