Prepared statement caching

Prepared statements are precompiled SQL statements that can be repeatedly invoked with different parameter values. Prepared statements reduce the need to compile the SQL statements.

You can improve the performance of agents and integration servers by using prepared statement caching, which caches executable statements that are used repeatedly.

By default, prepared statement caching is enabled for agents and integration servers.

You can determine the number of prepared statements to be maintained at any point of time in the cache, depending on your needs, by configuring the JDBC property statementCacheSize. By default, the prepared statement cache size is set to 10 for Oracle and DB2 pools. You can change this value depending on your needs, such as agent usage and load. Note, however, that if you increase this value, it may have an impact on performance and memory.