Purpose
You can use this statement to flush a plan cache.
Note
To flush the plan cache of a specified SQL statement or schema under an Oracle tenant, you need to use the DBMS_PLAN_CACHE system package.
Syntax
ALTER SYSTEM FLUSH PLAN CACHE [GLOBAL];
Parameters
| Parameter | Description |
|---|---|
| GLOBAL | Optional. If you do not specify this parameter, plan caches of the specified server are cleared. Otherwise, plan caches of all servers associated to the tenant are cleared. |
Examples
obclient> ALTER SYSTEM FLUSH PLAN CACHE GLOBAL;
Query OK, 0 rows affected