Purpose
ALTER SYSTEM FLUSH is a group of management statements used to clear or refresh temporary data such as internal database caches and logs.
Syntax
ALTER SYSTEM FLUSH object_option;
object_option:
SQL AUDIT
| PS CACHE
Parameters
| Parameter | Description |
|---|---|
| SQL AUDIT | Used to forcibly refresh and clear SQL audit records in memory. |
| PS CACHE | Used to clear the PS cache (Prepared Statement cache). |
Examples
Refresh and clear SQL audit records in the current tenant.
obclient> ALTER SYSTEM FLUSH SQL AUDIT;Clear the PS cache in the current tenant.
obclient> ALTER SYSTEM FLUSH PS CACHE;