Determines the amount of memory used by the JDBC Client to cache insensitive result set data.
Valid Values
-1 | 0 | x
If set to -1, the JDBC Client caches all insensitive result set data in memory. If the size of the result set exceeds available memory, an OutOfMemoryException is generated. Because the need to write result set data to disk is eliminated, the driver processes the data more efficiently.
If set to 0, the JDBC Client caches all insensitive result set data in memory, up to a maximum of 2 GB. If the size of the result set data exceeds available memory, the JDBC Client pages the result set data to disk. Because result set data may be written to disk, the JDBC Client may have to reformat the data to write it correctly to disk.
If set to x, where x is a positive integer, the JDBC Client caches all insensitive result set data in memory, using this value to set the size (in KB) of the memory buffer for caching insensitive result set data. If the size of the result set data exceeds the buffer size, the JDBC Client pages the result set data to disk. Because the result set data may be written to disk, the JDBC Client may have to reformat the data to write it correctly to disk. Specifying a buffer size that is a power of 2 results in more efficient memory use.
