Forum Discussion
Very Slow Oracle Connection Speed
Hello, I'm trying to connect to an on-primise Oracle database. I followed this instrucution and installed ODAC and instant client. This is the connection speed if I use sqldeveloper and each...
Yeah, i have the same slow performance accessing Oracle Database with the 64-bit ODAC installed.
Is there any update on it? I have checked with other client tools like PLSQL Developer, Toad etc, they retrieval is far faster as compared to Power BI Desktop. What we are missing here? Please some one from the product team should answer that question with the rectification.
In my case the situation got solved just by adding ' in the WHERE clause
something like SELECT A, B, C, D WHERE Key_Partition = '2019180512345'
because Oracle was doing an implicit conversion