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 | This parameter is optional. If this parameter is not specified, the plan cache of the local server is flushed. Otherwise, plan caches of all servers associated with the tenant are flushed. |
Examples
obclient> ALTER SYSTEM FLUSH PLAN CACHE GLOBAL;
Query OK, 0 rows affected