Purpose
Clears the cache.
Note
For an Oracle-compatible tenant, to clear the plan cache for a specified SQL or schema, use the DBMS_PLAN_CACHE system package.
Syntax
ALTER SYSTEM FLUSH {PLAN
| LIB } CACHE [GLOBAL]
Parameters
Parameter |
Description |
|---|---|
| PLAN | Clears the execution plan cache. |
| LIB | Clears the library cache. |
Examples
obclient> ALTER SYSTEM FLUSH PLAN CACHE GLOBAL;