Example documentationCACHESTATISTICS Locate this document in the navigation structure

 

Use of the system table SYSINFO.CACHESTATISTICS

Prerequisites

Activities

You can use the system table CACHESTATISTICS to determine the following database information, among other things:

  • Displaying all caches whose hit rate is below 90%

    SELECT name, accesscount, hitrate

    FROM SYSINFO.CACHESTATISTICS

    WHERE hitrate < '90'

  • Displaying the caches that show more failed accesses than successful ones

    SELECT *

    FROM SYSINFO.CACHESTATISTICS

    WHERE successfulaccesscount < unsuccessfulaccesscount