statement cache size  statement pipe max messages

Chapter 5: Setting Configuration Parameters

statement pipe active

Summary information

Default value

0

Range of values

0–1

Status

Dynamic

Display level

Comprehensive

Required role

System Administrator

Configuration group

Monitoring

statement pipe active controls whether Adaptive Server collects statement-level statistics. If both statement pipe active and statement pipe max messages are enabled, Adaptive Server collects the statement statistics for each query. You can retrieve the statistics for all executed statements using monSysStatement.





Copyright © 2005. Sybase Inc. All rights reserved. statement pipe max messages

View this book as PDF