CACHESTATISTICS 

Prerequisites

Log on to the database instance DEMODB.

Examples

You can use the system tableCACHE STATISTICS 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