Purpose
Deletes the plan cache.
Note
For an Oracle tenant, to clear the plan cache for specified SQL or schema, you must use the DBMS_PLAN_CACHE system package.
Syntax
ALTER SYSTEM FLUSH PLAN CACHE [GLOBAL];
Parameters
| Parameter | Description |
|---|---|
| GLOBAL | Optional. If this parameter is not specified, the plan cache of the current server is cleared. If this parameter is specified, the plan cache of all servers in the current tenant is cleared. |
Examples
obclient> ALTER SYSTEM FLUSH PLAN CACHE GLOBAL;
Query OK, 0 rows affected