sa_flush_cache system procedure

Empties all pages for the current database in the database server cache.

Syntax

sa_flush_cache( )

Remarks

Database administrators can use this procedure to empty the contents of the database server cache for the current database. This is useful in performance measurement to ensure repeatable results.

Privileges

You must have the SERVER OPERATOR system privilege.

Side effects

None

Example

The following example empties all pages for the current database in the database server cache.

CALL sa_flush_cache( );