Ads 468x60px


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.

Related Posts Plugin for WordPress, Blogger...