Show TOC

Example documentationCACHESTATISTICS

 

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