Summary information |
|
---|---|
Default value |
0 |
Range of values |
0–1 |
Status |
Dynamic |
Display level |
Comprehensive |
Required role |
System Administrator |
statement pipe active controls whether Adaptive Server collects statement-level statistics. If both statement pipe active and statement pipe max messages are enabled, Adaptive Server collects the statement statistics for each query. You can retrieve the statistics for all executed statements using monSysStatement.