SQL statement cache examples

The following are examples of onmode -W commands for changing SQL statement cache (SSC) settings. The changes are in effect for the current database server session only and do not change the ONCONFIG values. When you restart the database server, it uses the default SSC settings, if not specified in the ONCONFIG file, or the ONCONFIG settings. To make the changes permanent, set the appropriate configuration parameter.
onmode -W STMT_CACHE_HITS 2  # number of hits before statement is    
     # inserted into SSC
onmode -W STMT_CACHE_NOLIMIT 1  # always insert statements into           
     # the cache

This command has an equivalent SQL administration API function.

Copyright© 2018 HCL Technologies Limited