Contents Index sa_eng_properties system procedure sa_flush_statistics system procedure

ASA SQL Reference
  System Procedures and Functions
    System and catalog stored procedures

sa_flush_cache system procedure


Function 

Empties all pages in the database server cache.

Syntax 

sa_flush_cache ()

Permissions 

DBA authority required

Side effects 

None

Description 

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


Contents Index sa_eng_properties system procedure sa_flush_statistics system procedure