Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » System Procedures » System procedures

sa_eng_properties system procedure Next Page

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.

Permissions

DBA authority required

Side effects

None