Performance issue while fetching data from the Oracle OCI driver based datasource
Article ID: KB0083060
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | - |
Description
Performance issue while fetching data from the Oracle OCI driver based datasource. There is a Setting mismatch for Case Sensitivity and Trailing Spaces between the server and target datasources
Issue/Introduction
Performance issue while fetching data from the Oracle OCI driver based datasource
Resolution
Update the defaultValue for the jdbcds.comparisons_case_insensitive and jdbcds.trailing_spaces_included_in_comparison parameters to match with the Server side settings:
<common:defaultValue>false</common:defaultValue>
<common:displayName>Comparison is Case insensitive Mode</common:displayName>
<common:configID>jdbcds.comparisons_case_insensitive</common:configID>
<common:name>/runtime/query/trailingSpaceIncludeInComparison</common:name>
<common:defaultValue>true</common:defaultValue>
<common:displayName>Comparison With Trailing Space</common:displayName>
<common:configID>jdbcds.trailing_spaces_included_in_comparison</common:configID>
<common:defaultValue>false</common:defaultValue>
<common:displayName>Comparison is Case insensitive Mode</common:displayName>
<common:configID>jdbcds.comparisons_case_insensitive</common:configID>
<common:name>/runtime/query/trailingSpaceIncludeInComparison</common:name>
<common:defaultValue>true</common:defaultValue>
<common:displayName>Comparison With Trailing Space</common:displayName>
<common:configID>jdbcds.trailing_spaces_included_in_comparison</common:configID>
Feedback
Yes
No
Powered by
