Subscribe:

Ads 468x60px

Pages

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
0007-dbhitratio-001


2. If the hit ratio is below 95%, you will have to increase it.

Related Posts Plugin for WordPress, Blogger...