Toad World® Forums

TDP 3.2 Issue: High CPU utilization (and nothing's visibly running)


#1

Hi,

I have a strange issue that I was hoping someone had an idea of what I can check.

I usually only notice this when I have more than 1 tab open (and by tabs, it can be any combination of Editors or Query Builders). I have them open, but not usually running (or they have already completed). I’ll notice the fan in my laptop increase speed, and then I look at my task manager. I will see Toad.exe with 25% CPU utilization.

I then proceed to close all tabs open. It still is using high resources. I’ll then take note that the I/O Written Bytes by Toad.exe is extraordinarily large (as in multiple gigabytes). Today, I saw it was over 7 gigs. I found a large temp file in my temporary directory that was increasing in size as was the task manager’s i/o bytes written increasing.

I disconnected from the Oracle server I was using, and I’m prompted with a message saying if I disconnect it will cancel my running queries. But, what queries? I say no and look at my background processes. Nothing is listed, so it shouldn’t be running any queries. I disconnect and say yes. My fan slows and becomes quiet, but at this point in time, Toad is locked up. The message I just answered yes to does not go away, and the program stops responding, so I have to kill it.

Does anyone have an idea?

I’m using TDP Base Edition, v3.2.0.916 on a Windows XP SP3 machine, with 3GB of RAM, and an Intel Core i5 (dual core, 4 threads).

Thanks!


#2

Let me add a little back ground data that might be part of this.

When you execute a query it depends on how you execute it. If you use F5 the first 2500 are shown in the grid and the rest are written to disk in your temp folder. When you scroll to see rows it reads in more rows from disk. If you sorted on a column it has to bring in all of the rows to sort. This is one action that would cause heavy CPU as you describe.

When you execute using F9 the first 1000 rows are retrieved and then the retrieval is paused. Here you will see an open cursor in the background processes window. If you want to see more rows you scroll and it will pick up the retrieval again. This is mainly on Oracle connections.

So if you don’t mind open processes then use F9. Otherwise using F5 can have CPU and I/O.

Hope this helps.

Debbie


#3

I always use F9 to execute the query (keyboard is faster than me grabing and moving the mouse).

But as I mentioned, all documents were closed. Background processes in TDP showed no queries running.

Are you saying that this type of row retrieval would still be running even if the document it pertained to has been closed? If so, sounds like a bug :slight_smile:


#4

No. If all documents are closed then you wouldn’t’ get this issue. I can’t reproduce such an issue.

The next time this occurs can you access the windows menu and show all of the windows that are listed there. Also take a screenshot and post. Sometimes I can see something that will lead us down the right path.

Debbie


#5

You’re in luck, it just happened again to me.

I went to type a new query in an Editor window. One feature I really like about Toad is it’s auto-complete, how I can type the owner of a table followed by a period, and it will popup a list of tables and/or views there. Well, I noticed when I typed the owner of an oracle table, it did not give me any of the views, just tables. So I knew something was amiss. I also noticed my fan started whirling again and sure enough, toad was doing something in the background that I couldn’t see. So I closed all open documents. Opened up the background processes tab, and nothing was there. I then went to right-click on my connection and disconnect and it said again, “Cancel the queries that are currently running on connection…?”. So, I pressed yes. The popup stayed visible showing the “Yes” depressed… but wouldn’t go away. It was locked up.

I’m attaching 3 screen shots - one of the main toad screen showing no running processes, then of the task manager showing how it’s using the CPU, and lastly my “Temp” folder showing yet another large file it was creating. I could refresh the temp folder and see it increase in size dramatically. When I finally killed Toad.exe, that temp file was over 1.1 gigs in size.
Disk Usage.jpeg


#6

You’re in luck, it just happened again to me.

I went to type a new query in an Editor window. One feature I really like about Toad is it’s auto-complete, how I can type the owner of a table followed by a period, and it will popup a list of tables and/or views there. Well, I noticed when I typed the owner of an oracle table, it did not give me any of the views, just tables. So I knew something was amiss. I also noticed my fan started whirling again and sure enough, toad was doing something in the background that I couldn’t see. So I closed all open documents. Opened up the background processes tab, and nothing was there. I then went to right-click on my connection and disconnect and it said again, “Cancel the queries that are currently running on connection…?”. So, I pressed yes. The popup stayed visible showing the “Yes” depressed… but wouldn’t go away. It was locked up.

I’m attaching 3 screen shots - one of the main toad screen showing no running processes, then of the task manager showing how it’s using the CPU, and lastly my “Temp” folder showing yet another large file it was creating. I could refresh the temp folder and see it increase in size dramatically. When I finally killed Toad.exe, that temp file was over 1.1 gigs in size.
Toad.jpeg


#7

You’re in luck, it just happened again to me.

I went to type a new query in an Editor window. One feature I really like about Toad is it’s auto-complete, how I can type the owner of a table followed by a period, and it will popup a list of tables and/or views there. Well, I noticed when I typed the owner of an oracle table, it did not give me any of the views, just tables. So I knew something was amiss. I also noticed my fan started whirling again and sure enough, toad was doing something in the background that I couldn’t see. So I closed all open documents. Opened up the background processes tab, and nothing was there. I then went to right-click on my connection and disconnect and it said again, “Cancel the queries that are currently running on connection…?”. So, I pressed yes. The popup stayed visible showing the “Yes” depressed… but wouldn’t go away. It was locked up.

I’m attaching 3 screen shots - one of the main toad screen showing no running processes, then of the task manager showing how it’s using the CPU, and lastly my “Temp” folder showing yet another large file it was creating. I could refresh the temp folder and see it increase in size dramatically. When I finally killed Toad.exe, that temp file was over 1.1 gigs in size.
Task Manager.jpeg


#8

Just thought I’d give an update.

I’ve been able to get someone else to reproduce the issue and opened a ticket with technical support.

It seems to happen most often when you are in the editor and are starting to enter the WHERE part of the query. The very large temp file it creates, I have discovered, contains a dump of at least one of the tables that I am writing a query for. Not sure why it’s dumping the entire table, and is definitely something I don’t want it to do as there are tens of millions of rows.

Thanks!


#9

Thank you for reporting this issue.
We were able to reproduce and fix it. The fix should be in the next beta.
Thank you for helping us to make Toad better.

Aleksey