enable stmt cache monitoring

Summary information

Default value

0 (off)

Valid values

0 (off), 1 (on)

Status

Dynamic

Display level

Comprehensive

Required role

System administration

Configuration group

Monitoring

enable stmt cache monitoring enables or disables Adaptive Server to collect monitoring information about the statement cache. Once enabled, monStatementCache and monCachedStatement display valid data.