Toad using all PC resources

Toad for Oracle - Beta
1

Hi,

Not sure if anyone else is having this issue with the Beta, but I’ve had to go into Task Manager at least two or three times last week and kill Toad. The problem is my machine would be running fine, then all of a sudden it would become non-responsive to keystroke or mouse actions. In each case, once I was able to get the Task Manager to come up, I found multiple instances of Toad running in Task Manager and had to kill them both. Once I did that, everything was back to normal. Note: this isn’t a case of Toad crashing and me restarting Toad without first going into Task Manager and killing any orphaned Toad processes before restarting. I have one repeatable test case where if I copy a few Stored Procedurers into an anonomus pl/sql block and attempt to execute it, this issue will occur. Not sure what’s triggered it in other cases.

Example:

BEGIN

    PROCEDURE1;

    PROCEDURE2;

    ...

    PROCEDURE10;

END;

If there’s anything further I can provide to help out in resolving this, please let me know.

–Mitch

2

Hi Mitch,

Have you been browsing these forums within Toad? If so, this is most likely the cause of your orphan processes. We are working hard to try to resolve this
issue. If you can make this happen without logging into ToadWorld (forums), please let us know.

Thanks,

Brad

From: msacks_703 [mailto:bounce-msacks_703@beta.toadworld.com]

Sent: Monday, May 06, 2013 10:51 AM

To: toadoraclebeta@beta.toadworld.com

Subject: [Toad for Oracle - Beta Discussion Forum] Toad using all PC resources

Hi,

Not sure if anyone else is having this issue with the Beta, but I’ve had to go into Task Manager at least two or three times last week and kill Toad. The problem
is my machine would be running fine, then all of a sudden it would become non-responsive to keystroke or mouse actions. In each case, once I was able to get the Task Manager to come up, I found multiple instances of Toad running in Task Manager and had to
kill them both. Once I did that, everything was back to normal. Note: this isn’t a case of Toad crashing and me restarting Toad without first going into Task Manager and killing any orphaned Toad processes before restarting. I have one repeatable test case
where if I copy a few Stored Procedurers into an anonomus pl/sql block and attempt to execute it, this issue will occur. Not sure what’s triggered it in other cases.

Example:

BEGIN

   PROCEDURE1;

   PROCEDURE2;

   ...

   PROCEDURE10;

END;

If there’s anything further I can provide to help out in resolving this, please let me know.

–Mitch

3

Hi Brad,

I closed out of the Forums window and was able to run my anonymous PL/SQL block without error, so I’ll just keep the Forums window closed whenever working, and just open it as necessary. If you want me to test when you have a fix for this, please let me know.

Thanks,

–Mitch

4

I’m hoping this is resolved now. In a quick in-house test, recent attempts at a fix look promising. If you can try as well (leaving forums open) in next beta that would be most helpful.

Thanks,

Michael

5

I just downloaded the latest beta, I’ll run some tests and let you know.

6

So far, no issues. I’ve run the scenarios that caused issues for me in the past, and I’ve yet to experiance a lock up. I’ll continue to test throughout the day and let you know if this issue recurs.