Wednesday, 31 August 2011

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
003-ST04

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

Be the first to like this post.

No comments:

Post a Comment