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.