Toad World® Forums

Toad Hang on F9

All,

This relates to Toad for Oracle, Beta 12.12.0.29

I have a simple SQL statement that generates insert and update statements - just over 370,000 of them.

So I run the query, export the result column, paste that into a separate editor window on a different connection.

Then I select the first statement, which happens to be an update statement, and hit F9 in order to test the generated update statement.
Toad goes into a hang. In the lower right corner the progress bar does not show anything in progress.

Inserting a blank line in between the highlighted statement and the rest of the script makes no difference.
Also, Ctrl-Enter behaves the same as F9: Toad hangs and shows no progress at all.

Is this a known issue?

Kind regards,
Abe Kornelis

All,

I tried the same scenario on 12.10, and there it’s even worse: Tad hangs and will not be terminated.
The only option is to use the Windows Task Manager to kill the process :frowning:

Kind regards,
Abe

All,

another addition: F5 displays the exact same behavior. So I checked the Windows Resource Monitor.
It reported the Toad session as “Not Responding”, having 11 threads, consuming 97-99% of both CPUs.

Checking again: Toad is now reported as “Not Responding” 10 threads, consuming ca. 50% of both CPUs.

This situation has persisted for several minutes…

Maybe this information helps?

Kind regards,
Abe

Yet another addition: after some ten minutes Toad finally goes back to being responsive, but it does not execute any statement, nor does it produce an error message of any kind.

So, being stubborn, I try F5 again, and get an error message “Out of Memory” :frowning:

Does any of you have an idea what is going on? What we can do to avoid the excessive wait time?

Kind regards,
Abe

It’s likely waiting to parse. Executing requires knowledge of the statements and 370k statements is a lot to digest. Has the Navigator populated yet? After parsing it should execute without issue.

There was a somewhat recent thread about fast edit/execute cycles that is related. I have it logged to investigate, but I need more than a summer release cycle to look at it.

Michael

On Sep 20, 2017, at 2:36 AM, kornelis.abe bounce-kornelisabe@toadworld.com wrote:

Toad Hang on F9

Thread created by kornelis.abe
All,

This relates to Toad for Oracle, Beta 12.12.0.29

I have a simple SQL statement that generates insert and update statements - just over 370,000 of them.

So I run the query, export the result column, paste that into a separate editor window on a different connection.

Then I select the first statement, which happens to be an update statement, and hit F9 in order to test the generated update statement.

Toad goes into a hang. In the lower right corner the progress bar does not show anything in progress.

Inserting a blank line in between the highlighted statement and the rest of the script makes no difference.

Also, Ctrl-Enter behaves the same as F9: Toad hangs and shows no progress at all.

Is this a known issue?

Kind regards,

Abe Kornelis

==========

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta Forum
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.

I’ll try to reproduce using the info from your additional emails. When I responded earlier it was from my phone and iOS mail only showed your initial message, not the 3 following it.

Michael

Michael,

No problem. I tried to attach the file I created.
Unfortunately that won’t work.

I’ll be happy to mail it, though, if you have the email address for me…

Kind regards,
Abe

michael staszewski quest com

You didn’t mention anything about doing a commit after your update/insert statement. If you really didn’t do a commit, then you are dealing with a locking issue.

On Wed, Sep 20, 2017 at 9:57 AM, Michael Staszewski bounce-mstaszew@toadworld.com wrote:

RE: Toad Hang on F9

Reply by Michael Staszewski
michael staszewski quest com

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or Unsubscribe from Toad for Oracle - Beta Forum notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag this post as spam/abuse.


Phyllis Helton

Data Magician

Security Gestapo
Digital Products & Strategies, Cru | Data Sciences & Analytics
Office :phone: 407-515-4452

phyllis.helton@cru.org

Phyllis,

theoretically, you are right, it could have been a locking issue with any other user or process on the system.

The work-around I found was to paste the file (10K lines at a time) in a SQLPLUS session. That worked like a charm.

I’m pretty sure it was parsing that took so long it got me to think the entire session was hanging.

Kind regards & thanks for the suggestion!
Abe

One thing you can do when Toad is hanging, to try to determine what’s going on, is start task manager and see how busy your processor is.

If it is idle, we are probably waiting for Oracle. If it is busy, Toad is taking a long time to do something.