Purpose
You can use this statement to delete a cache.
Note
To delete the plan cache of a specified SQL statement or schema under an Oracle-compatible tenant, you need to use the DBMS_PLAN_CACHE system package.
Syntax
ALTER SYSTEM FLUSH {PLAN
| LIB } 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;