Enable Server Result Cache
- Last Updated: October 27, 2020
- 1 minute read
- DataDirect Connectors
- ODBC
- Oracle Database Wire Protocol 8.0
- Documentation
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)