Procedure Cache Hit Ratio for database
What is it?
The hit ratio is a mean value that gives a snapshot of a short period of time before the analysis. This value should always be above 95%, even during periods of heavy workload. If the hit ratio is significantly below 95%, the data cache could be too small.
To check the hit ratio:
1. Execute ST04
2. If the hit ratio is below 95%, you will have to increase it.