SMC_NAME_CUR_STMT_PAGE_PHYSICAL_READ  SMC_NAME_CUR_STMT_QUERY_PLAN_TEXT

Chapter 2: Data Items and Statistical Types

SMC_NAME_CUR_STMT_PAGE_WRITE

Description

Reports the number of data pages written to a database device, accumulated by the currently executing SQL statement.

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

LONG

LONG

DOUBLE

DOUBLE



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

View this book as PDF