Summary information |
|
---|---|
Default value |
0 |
Range of values |
0–1 |
Status |
Dynamic |
Display level |
Comprehensive |
Required role |
System Administrator |
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.