SMC_NAME_CUR_STMT_TEXT_BYTE_OFFSET  SMC_NAME_DATA_CACHE_EFFICIENCY

Chapter 2: Data Items and Statistical Types

SMC_NAME_DATA_CACHE_CONTENTION

Description

Reports the fraction of the requests for a data cache’s spinlock that were forced to wait (spinlock_waits divided by spinlock_requests).

Version compatibility

11.0 and later

Data item type

Result

Server level

No

Required keys

DATA_CACHE_ID

Optional keys

None

Statistic types and datatypes

VALUE_ SAMPLE

VALUE_ SESSION

RATE_ SAMPLE

RATE_ SESSION

AVG_ SAMPLE

AVG_ SESSION

DOUBLE

DOUBLE



Copyright © 2005. Sybase Inc. All rights reserved. SMC_NAME_DATA_CACHE_EFFICIENCY

View this book as PDF