plan text pipe active

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.