Showing posts with label Procedure. Show all posts
Showing posts with label Procedure. Show all posts

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.