Contents Index sa_flush_cache system procedure sa_get_dtt system procedure

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

sa_flush_statistics system procedure


Function 

Saves all cost model statistics in the database server cache.

Syntax 

sa_flush_statistics ()

Permissions 

DBA authority required

Side effects 

None

Description 

Database administrators can use this procedure to ensure that cost model statistics in the database server cache that have been created and/or gathered but not yet saved to disk are flushed out with immediate effect. Under normal operation it should not be necessary to execute this procedure because the server automatically writes out statistics to disk on a periodic basis.


Contents Index sa_flush_cache system procedure sa_get_dtt system procedure