skip to main content
Connection property descriptions : EnableServerResultCache
  

Try DataDirect Drivers Now

EnableServerResultCache

Purpose

Determines whether the driver enables Oracle’s server-side resultset caching feature, which stores the result set in database memory so that it can be reused. Server-side resultset caching can improve performance if your application executes the same query multiple times.
This property only applies to connections to Oracle 11g and higher database servers that support server-side resultset caching.

Valid values

true | false

Behavior

If set to true, the driver enables server-side resultset caching.
If set to false, the driver does not enable server-side resultset caching.

Notes

*Oracle Autonomous Data Warehouse Cloud requires server-side result caching to be enabled. Therefore, this property is ignored and server-side result caching is always enabled when connected to Oracle Autonomous Data Warehouse.

Data source method

setEnableServerResultCache

Default

false

Data type

boolean

See also

Performance considerations