SMC_NAME_CUR_STMT_CONTEXT_ID  SMC_NAME_CUR_STMT_ELAPSED_TIME

Chapter 2: Data Items and Statistical Types

SMC_NAME_CUR_STMT_CPU_TIME

Description

Reports the amount of time (in seconds) that the currently executing SQL statement has spent in the running state.

Version compatibility

11.5 and later

Data item type

Result

Server level

No

Required keys

SMC_NAME_SPID

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_CUR_STMT_ELAPSED_TIME

View this book as PDF