Reports the fraction of the page reads satisfied, which is computed from the following formula:
cache_hits / (cache_hits + cache_misses) * 100
11.0 and later
Result
No
DATA_CACHE_ID
None
VALUE_ SAMPLE |
VALUE_ SESSION |
RATE_ SAMPLE |
RATE_ SESSION |
AVG_ SAMPLE |
AVG_ SESSION |
|---|---|---|---|---|---|
DOUBLE |
DOUBLE |
When SMC_NAME_DATA_CACHE_MISS overstates
the number of physical page reads, SMC_NAME_DATA_CACHE_HIT_PCT understates the
percentage of cache hits.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
