Problem Note 66899: PROC DS2 might cause slow response times when you access an Oracle table with VARCHAR2 bind variables
 |  |  |  |  |
You might experience slow response times from SAS® Real-Time Decision Manager when accessing VARCHAR2 bind variables from Oracle tables via SAS® Federation Server.
When querying VARCHAR2 bind variables from Oracle tables with the SAS Federation Server, this column is cast as NVARCHAR2 variables and existing table indexes cannot be used. This behavior can cause performance issues.
There is no workaround from SAS, but an Oracle database administrator can create a function-based index.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Federation Server | Solaris for x64 | 4.2 | 4.2 | 9.4 TS1M7 | |
| Linux for x64 | 4.2 | 4.2 | 9.4 TS1M7 | |||
| HP-UX IPF | 4.2 | 4.2 | 9.4 TS1M7 | |||
| 64-bit Enabled Solaris | 4.2 | 4.2 | 9.4 TS1M7 | |||
| 64-bit Enabled AIX | 4.2 | 4.2 | 9.4 TS1M7 | |||
| Microsoft® Windows® for x64 | 4.2 | 4.2 | 9.4 TS1M7 | |||
Viya on Linux: An update for this issue is available for SAS Viya 3.5. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.5 for Linux Deployment Guide at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.5&softwareContextId=softwareUpdatesA fix for this issue for SAS Threaded Kernel Extension for Oracle 9.44 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/J1E.html#66899A fix for this issue for SAS Federation Server 4.2 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/Y46.html#66899| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2020-11-18 13:35:05 |
| Date Created: | 2020-11-05 15:10:36 |