plan text pipe active determines whether SAP ASE collects query plan text.
|
Summary Information |
|
|---|---|
|
Default value |
0 |
|
Range of values |
0–1 |
|
Status |
Dynamic |
|
Display level |
Comprehensive |
|
Required role |
System administrator |
|
Configuration group |
Monitoring |
If both plan text pipe active and plan text pipe max messages are enabled, SAP ASE collects the plan text for each query. You can use monSysPlanText to retrieve the query plan text for all user tasks.