permission cache entries  plan text pipe max messages

Chapter 5: Setting Configuration Parameters

plan text pipe active

Summary information

Default value

0

Range of values

0–1

Status

Dynamic

Display level

Comprehensive

Required role

System Administrator

Configuration group

Monitoring

plan text pipe active determines whether Adaptive Server collects query plan text. If both plan text pipe active and plan text pipe max messages are enabled, Adaptive Server collects the plan text for each query. You can use monSysPlanText to retrieve the query plan text for all user tasks.





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

View this book as PDF