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 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

This connection option can affect performance.

Default

0 (Disabled)

GUI Tab