skip to main content
Connection Option Descriptions : Enable Server Result Cache
  

Try DataDirect Drivers Now

Enable Server Result Cache

Attribute

EnableServerResultCache (ESRC)

Purpose

Determines whether the driver sets the RESULT_CACHE_MODE session parameter to FORCE.
This option only applies to connections to Oracle 11g or higher database servers that support server-side result set caching.
This connection option can affect performance.

Valid Values

0 | 1

Behavior

If set to 1 (Enabled), the driver sets the RESULT_CACHE_MODE session parameter to FORCE.
If set to 0 (Disabled), the driver does not sets the RESULT_CACHE_MODE session parameter.

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 the Oracle Autonomous Data Warehouse service.
*This connection option can affect performance.

Default

0 (Disabled)

GUI Tab

Advanced tab

See also

Performance Considerations