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:

In SCC, open the SAP Adaptive Server Enterprise Monitor view, or Administration Console Configuration screen, and change the value of statement cache size to a nonzero value.
Log in to the server and execute the sp_configure system procedure to set the value of the statement cache size parameter to a nonzero value.