Toad World® Forums

Toad Data Point querying slow after Oracle 12c upgrade

Hello,

I have been on version 3.6 (3.6.1.3294) for some time and everything has been working well. I am connecting to Oracle databases most of the time, and previously they have all been on Oracle 11g. Recently they have upgraded a couple databases to 12c, and my queries from Toad Data Point are running extremely slow. I initially thought it was an Oracle issue, but I can run the same queries through some other Oracle tools (e.g., Oracle SQL Developer, SQL Plus, Toad for Oracle) and everything runs fine. It is only in Toad Data Point that I have this issue.

Has anyone experienced the same issue or have an idea why this might be occurring? I even reinstalled Data Point, and I have also tried the new 3.7 version. I am using the Oracle native client to connect, so no ODBC is involved.

Thank you all for your time and input.

Regards,

Joe

Hi Joe,

What type of Oracle connection do you use in TDP 3.6 and 3.7? Is it native Oracle connection or ODBC connection? What Oracle client do you use? Is it 32 or 64 bit client?

If you use 64 bit client for TDP3.7 I’d suggest trying 32 bit client.

Regards

Aleksey

Hi Aleksey,

I am currently using the native Oracle connection, not the ODBC connection. I actually don't know which architecture I am using. Is there an easy way to check that? I am guessing it's the 64 bit connection, but I am unsure how to change it to 32-bit.

If I go into the connection properties, I see "Oracle Instant Client" listed under Current Home. If I click the drop down there, I have two options: "Oracle Instant Client" and " (64 bit)". If I click the " (64 bit)" option, it wipes out my database name, and then changes back to "Oracle Instant Client". It looks like it should not be listed that way but I cannot figure out how to fix it. I have attached a screenshot of the two options.

Thank you so much for your help with this. I appreciate it.

Regards,

Joe

Hi Joe,

You could use this article to check your clients. There are instructions how to install 32 and 64 bit clients on the same PC but I’d suggest to uninstall the 64 bit client (use Control panel to do it) and install 32 bit client.

Regards

Aleksey

Hi Aleksey,

I was able to move the 64 bit instant client folder out of the C:\Oracle folder, and I verified that it did indeed remove it from my machine. There was only one entry under the connection settings. If I removed the 32 bit as well, no entries appeared, so it looked good. However, the query was still running extremely slow. I even swapped back to the 64 bit just to check, and it was still slow. I am unsure where to go at this point, but I might send in a support ticket to have it looked at.

If you have any other suggestions, let me know. Thanks again for your responses.

Regards,

Joe

Hi Joe,

I created QAT-6237 to track the issue

Thank you for reporting it.

Aleksey

Hi Joe,

I am trying to reproduce this issue by connecting to 12c, but unfortunately I can not reproduce until now.

Would you mind to provide us these information?

  1. All sql slow, or just specific sql running very slow?

  2. If only specific ones, could you please provide us the SQL statement?

Thanks

Andy Chang

Aleksey,

Thank you so much for putting in a ticket for me. I appreciate it.

Hi Andy,

It seems like only some are causing the slow down and some run fine. It may just be that the performance is exponentially bad the longer the query normally takes. A query that normally took 2 seconds may take 10 or so, and a query that took a minute might take 20 minutes. Something like that.

I am not sure I can provide the SQL as it is for my company and contains proprietary information. I can try to write a query that takes longer to run and does not contain proprietary information. I will set something up and reply once I have something.

Thanks,

Joe

Andy,

I am unable to create a query that runs slowly but does not contain company-specific data structures. Would I be able to send a sample query to your team directly without attaching to the public forum?

Regards,

Joe

Yes. You can send to me.

debbie.peabody@quest.com

We used you example but were never able to reproduce the issue. We are closing QAT-6237.

Hi Debbie,

Yes, I saw that from Joseph Motley on Friday. I am still unable to figure out the issue on my end as well. I will keep looking into the issue on my end, and hopefully find a solution on my end.

Thank you so much for your help with this.

Regards,

Joe


Joe Saffo | Aera Energy LLC | Business Resources – Field Efficiency | Office: 661-665-5301 | Schedule 9/80 B

From: Debbie Peabody [mailto:bounce-Debbie_Peabody@toadworld.com]

Sent: Monday, October 12, 2015 1:04 PM

To: toaddatapoint@toadworld.com

Subject: RE: [Toad Data Point - Discussion Forum] Toad Data Point querying slow after Oracle 12c upgrade

RE: Toad Data Point querying slow after Oracle 12c upgrade

Reply by Debbie Peabody

We used you example but were never able to reproduce the issue. We are closing QAT-6237.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad Data Point - General
notifications altogether.

Toad Data Point - Discussion Forum

Flag
this post as spam/abuse.

Hello Debby,

Hope you are doing good.

We too have recently upgraded our database to 12c and since then our queries just keep running and we need to eventually kill the running query. It neither gives any error.

We were informed that we should update the Oracle client also to 12c which we have done but we have ended up unsuccessful.

Hence, we are really not able to understand if this is an issue on TOAD or ORACLE.

Appreciate any help from you on this regard.

Thanks,
Sachin

Sachin,

We are running Oracle 12C and use Toad Data Point 4.1.0.226…no issues. Have you tried upgrading Toad to the latest version?

David

Hello David,

Many thanks for your response.

We are in the process of upgrading the same.

However, Is it mandatory to have Oracle 12C running on Toad Data Point 4.1??

The reason been there are queries which do give an output and some which just do not return and keeps running. Hence, making it difficult where actually the problem lies?

Regards,

Sachin

I doubt that it is required, just a suggestion. Like you said, it could be the database.

Sometimes uninstalling Oracle clients do not fully uninstall and can cause problems. Goolge search unistalling Oracle clients and you can find out how to fully uninstall it by manually removing files and editing registry entries. Mulitple Oracle clients can cause connection confusion sometimes.

Hi Sachin

Could you please provide more information to us for example:

Oracle server version,Client Version, Oracle Client bitness and How do you connect Oracle, direct/TNS/OCI.

Thanks

Andy

I used Oracle 12c with 12c client and TDP 4.2 today. Execution was quite fast. But getting column data is very slow. IThis makes dragging a table on the Query Builder very slow. entered QAT-10846 for the column retireval. Other than this I don’t see any issues. Once the column data is retrieved it is cached for that session and there are no more slows.