SMC_NAME_STP_EXECUTION_CLASS  SMC_NAME_STP_LINE_NUM

Chapter 2: Data Items and Statistical Types

SMC_NAME_STP_HIT_PCT

Description

Reports the percentage of times that a stored procedure execution found the procedure’s query plan in procedure cache and available for use.

Version compatibility

11.0 and later

Data item type

Result

Server level

Yes

Required keys

None

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_STP_LINE_NUM

View this book as PDF