The transaction SQL cache is enabled by default, meaning that the results of SQL queries will be cached. To disable it, the curam.transaction.sqlquerycache.disabled property must be set to true in the Application.prx file.
Storing the results of SQL queries that return large result sets may lead to memory problems in transactions that endure for a long period of time. The most likely queries that could lead to such problems are those that return data of type CLOB and BLOB. To cater for SQL queries that return large result sets, a property is available to control the size of fields of type CLOB or BLOB that may be stored in the transaction SQL query cache. This property is called curam.sqlquerycache.lob.max.size and it's default size is set to 500KB.
Further details concerning these properties may be found in Cúram Configuration Parameters.