Setting the Statement Cache Size

To set the statement cache size, use either SCC, or the sp_configure system procedure.

If you do not configure the statement cache in the monitored server, SCC displays an error when you open the Statement Cache tab on the SAP Adaptive Server Enterprise Monitor View Caches screen:
[error#=12052] Collection of monitoring data for table
'monCachedStatement' requires that the 'statement cache size'
configuration option(s) be enabled. To set the necessary
configuration, contact a user who has the System Administrator
(SA) role.
To enable the statement cache, use one of these methods: