Setting the Statement Cache Size

You can use one of two methods to set the statement cache size.

If you do not configure the statement cache in the monitored Adaptive Server, Sybase Control Center displays an error when you open the Statement Cache tab on the Adaptive Server 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.

Use either method to enable the statement cache:

In the Sybase Control Center, open the Adaptive Server Monitor View Server or Administration Console Configuration screen and change the value of statement cache size to a non-zero value.
Log in to the Adaptive Server and execute the sp_configure system procedure to set the value of the statement cache size parameter to a non-zero value.