Toad World® Forums

Editor hangs executing script with F5


#1

Howdy,

In .31, I accidentally hit F5 in the Editor that contained this work-in-progress:

SELECT
DOB.OWNER, COUNT(*)
FROM DBA_OBJECTS DOB join sys.user$ su on dob.owner = su.name
where su.user# > 25
GROUP BY DOB.OWNER
ORDER BY 1;

select * from sys.user$ where type# = 1 order by user#;

The first SQL ran fine against my 11.2.0.3 DB and displayed its output, but Toad hangs trying to run “2 of 2”. I’ve tried this multiple times, and Toad hangs each time. Running them separately with F9 (hey, the F5 was an accident, OK?), the resulting grids work perfectly as expected.

Let me know if there’s more info needed for this.

Thanks!
Rich


#2

Rich, I’m unable to reproduce in .31 (tried both 32 and 64 bit). If you do the same in 12.6 does it also hang?

From: Rich J. [mailto:bounce-rjesse@toadworld.com]

Sent: Tuesday, January 06, 2015 5:38 PM

To: toadoraclebeta@toadworld.com

Subject: [Toad for Oracle - Beta Discussion Forum] Editor hangs executing script with F5

Editor hangs executing script with F5

Thread created by Rich J.

Howdy,

In .31, I accidentally hit F5 in the Editor that contained this work-in-progress:

SELECT

DOB.OWNER, COUNT(*)

FROM DBA_OBJECTS DOB join sys.user$ su on dob.owner = su.name

where su.user# > 25

GROUP BY DOB.OWNER

ORDER BY 1;

select * from sys.user$ where type# = 1 order by user#;

The first SQL ran fine against my 11.2.0.3 DB and displayed its output, but Toad hangs trying to run “2 of 2”. I’ve tried this multiple times, and Toad hangs each time. Running them separately
with F9 (hey, the F5 was an accident, OK?), the resulting grids work perfectly as expected.

Let me know if there’s more info needed for this.

Thanks!

Rich

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.


#3

Hey Michael,

[blush] I’m on 64-bit.

Being slightly more patient today, I think I see what’s happening now. 12.6 comes back in 333ms and outputs all ~2200 rows in the output. 12.7b does eventually come back, but it seems like it’s taking 30-60s to paint the text in the script output area. And while it’s doing that, Win7 fades out Toad, goes to a busy mouse pointer and says Toad’s not responding. The wonderful Process Explorer tool says Toad’s taking up ~100% of 1 core/thread of CPU (~12-13% CPU of a quad-core HT i7) during this time. If Toad options matter, I have the “Processing Script…2 of 2” popup window during the F5 script execute.

The second query only returns 45 rows, but the wide output causes SQL*Plus-like word wrapping and column headering (new word I just unvented), and the output balloons to 2181 rows, including the 20 from the first query.

FWIW, Toad says my laptop is:

Computer:

5.2 Total Memory : 17080455168 (15.91 Gb)
5.3 Free Memory : 12396101632 (11.54 Gb)
5.4 Total Disk : 319240007680 (297.32 Gb)
5.5 Free Disk : 40053071872 (37.30 Gb)
5.6 System Up Time : 3 day(s), 11 hour(s), 21 minute(s), 26 second(s)
5.7 Processor : Intel® Core™ i7-3720QM CPU @ 2.60GHz
5.12 Virtual Machine:

Operating System:

6.1 Type : Microsoft Windows 7 (64 bit)
6.2 Build #: 7601

Does that mess help shed any light?

Thanks!
Rich


#4

On my DB I don’t get nearly that much data with your queries, but I’ll setup a case to get that much. It’s probably the population of the script output area as
you note.

Thanks,

Michael

From: Rich J. [mailto:bounce-rjesse@toadworld.com]

Sent: Wednesday, January 07, 2015 10:33 AM

To: toadoraclebeta@toadworld.com

Subject: RE: [Toad for Oracle - Beta Discussion Forum] Editor hangs executing script with F5

RE: Editor hangs executing script with F5

Reply by Rich J.

Hey Michael,

[blush] I’m on 64-bit.

Being slightly more patient today, I think I see what’s happening now. 12.6 comes back in 333ms and outputs all ~2200 rows in the output. 12.7b
does eventually come back, but it seems like it’s taking 30-60s to paint the text in the script output area. And while it’s doing that, Win7 fades out Toad, goes to a busy mouse pointer and says
Toad’s not responding. The wonderful Process Explorer tool says Toad’s taking up ~100% of 1 core/thread of CPU (~12-13% CPU of a quad-core HT i7) during this time. If Toad options matter, I have the “Processing Script…2 of 2” popup window during the
F5 script execute.

The second query only returns 45 rows, but the wide output causes SQL*Plus-like word wrapping and column headering (new word I just unvented), and the output balloons to 2181 rows, including the
20 from the first query.

FWIW, Toad says my laptop is:

Computer:


5.2 Total Memory : 17080455168 (15.91 Gb)

5.3 Free Memory : 12396101632 (11.54 Gb)

5.4 Total Disk : 319240007680 (297.32 Gb)

5.5 Free Disk : 40053071872 (37.30 Gb)

5.6 System Up Time : 3 day(s), 11 hour(s), 21 minute(s), 26 second(s)

5.7 Processor : Intel® Core™ i7-3720QM CPU @ 2.60GHz

5.12 Virtual Machine:

Operating System:


#5

I’ve tried with a few different queries returning a few thousand lines of output and am seeing comparable speeds to 12.6. Please send me your user files folder
when you have time… again. I’m at a different computer and don’t have access to the user files you sent a few weeks back.

Thanks,

Michael

From: Rich J. [mailto:bounce-rjesse@toadworld.com]

Sent: Wednesday, January 07, 2015 10:33 AM

To: toadoraclebeta@toadworld.com

Subject: RE: [Toad for Oracle - Beta Discussion Forum] Editor hangs executing script with F5

RE: Editor hangs executing script with F5

Reply by Rich J.

Hey Michael,

[blush] I’m on 64-bit.

Being slightly more patient today, I think I see what’s happening now. 12.6 comes back in 333ms and outputs all ~2200 rows in the output. 12.7b
does eventually come back, but it seems like it’s taking 30-60s to paint the text in the script output area. And while it’s doing that, Win7 fades out Toad, goes to a busy mouse pointer and says
Toad’s not responding. The wonderful Process Explorer tool says Toad’s taking up ~100% of 1 core/thread of CPU (~12-13% CPU of a quad-core HT i7) during this time. If Toad options matter, I have the “Processing Script…2 of 2” popup window during the
F5 script execute.

The second query only returns 45 rows, but the wide output causes SQL*Plus-like word wrapping and column headering (new word I just unvented), and the output balloons to 2181 rows, including the
20 from the first query.

FWIW, Toad says my laptop is:

Computer:


5.2 Total Memory : 17080455168 (15.91 Gb)

5.3 Free Memory : 12396101632 (11.54 Gb)

5.4 Total Disk : 319240007680 (297.32 Gb)

5.5 Free Disk : 40053071872 (37.30 Gb)

5.6 System Up Time : 3 day(s), 11 hour(s), 21 minute(s), 26 second(s)

5.7 Processor : Intel® Core™ i7-3720QM CPU @ 2.60GHz

5.12 Virtual Machine:

Operating System:


#6

SPAM emails have been sent! :wink:

Thanks, Michael!

Rich


#7

Got them, thanks. The character case setting of your Default editor style has been lost due to some recent changes and I’m passing an invalid value to the editor component. I’ll fix this for next beta. In the meantime open Options and
change the Default editor style’s character case to a valid value like Unchanged.

Michael

From: Rich J. [mailto:bounce-rjesse@toadworld.com]

Sent: Wednesday, January 07, 2015 12:47 PM

To: toadoraclebeta@toadworld.com

Subject: RE: [Toad for Oracle - Beta Discussion Forum] Editor hangs executing script with F5

RE: Editor hangs executing script with F5

Reply by Rich J.

SPAM emails have been sent! :wink:

Thanks, Michael!

Rich

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.


#8

A ha! Changed the style from " " to “Unchanged” and now she returns in 316ms.

Thanks, Michael!
Rich


#9

I have the same problem with the final version of Toad for Oracle 12.7.

But in my case, the style´s character case is set to “Unchanged” and the problem still exists.

Can anyone help?


#10

Do you have a sample script that you can send to reproduce it? You can email it to me directly.

michael.staszewskiquest.com

Thanks,

Michael

From: jsandner [mailto:bounce-jsandner@toadworld.com]
Sent: Friday, June 19, 2015 10:03 AM
To: toadoraclebeta@toadworld.com
Subject: RE: [Toad for Oracle - Beta Discussion Forum] Editor hangs executing script with F5

RE: Editor hangs executing script with F5

Reply by jsandner

I have the same problem with the final version of Toad for Oracle 12.7.

But in my case, the style´s character case is set to “Unchanged” and the problem still exists.

Can anyone help?

To reply, please reply-all to this email.

Stop receiving emails on this subject.
Or Unsubscribe from Toad for Oracle - Beta notifications altogether.
Toad for Oracle - Beta Discussion Forum

Flag this post as spam/abuse.


#11

Sorry, but I can´t send you a sample script.

In my case I have use 33 columns with grants.


#12

GRANT SELECT ON schema.table to user;
GRANT SELECT ON schema.table to user;
GRANT SELECT ON schema.table to user;
GRANT SELECT ON schema.table to user;
GRANT SELECT ON schema.table to user;
GRANT SELECT ON schema.table to user;
GRANT SELECT ON schema.table to user;
GRANT SELECT ON schema.table to user;
GRANT SELECT ON schema.table to user;
GRANT SELECT ON schema.table to user;
GRANT SELECT ON schema.table to user;
GRANT SELECT ON schema.table to user;
GRANT SELECT ON schema.table to user;
GRANT SELECT ON schema.table to user;
GRANT SELECT ON schema.table to user;
GRANT EXECUTE ON schema.function to user;
GRANT EXECUTE ON schema.function to user;
GRANT EXECUTE ON schema.function to user;

GRANT SELECT ON schema.table to user;
GRANT SELECT ON schema.table to user;
GRANT SELECT ON schema.table to user;
GRANT SELECT ON schema.table to user;
GRANT SELECT ON schema.table to user;
GRANT SELECT ON schema.table to user;
GRANT SELECT ON schema.table to user;
GRANT SELECT ON schema.table to user;
GRANT SELECT ON schema.table to user;
GRANT SELECT ON schema.table to user;
GRANT SELECT ON schema.table to user;
GRANT SELECT ON schema.table to user;
GRANT SELECT ON schema.table to user;
GRANT SELECT ON schema.table to user;

I hope this helps to reproduce the problem.


#13

I can’t reproduce using your sample. I changed “schema.table” to scott.emp and “user” to another user. I get 3 ORA errors for the GRANT EXECUTE statements as
expected, but I assume you had PL/SQL objects listed there instead of schema.table. It might be related to a Toad setting. If you zip and send me your user files folder I’ll take a look. You can send that to me offline.

From: jsandner [mailto:bounce-jsandner@toadworld.com]

Sent: Friday, June 19, 2015 10:24 AM

To: toadoraclebeta@toadworld.com

Subject: RE: [Toad for Oracle - Beta Discussion Forum] Editor hangs executing script with F5

RE: Editor hangs executing script with F5

Reply by jsandner

GRANT SELECT ON schema.table to user;

GRANT SELECT ON schema.table to user;

GRANT SELECT ON schema.table to user;

GRANT SELECT ON schema.table to user;

GRANT SELECT ON schema.table to user;

GRANT SELECT ON schema.table to user;

GRANT SELECT ON schema.table to user;

GRANT SELECT ON schema.table to user;

GRANT SELECT ON schema.table to user;

GRANT SELECT ON schema.table to user;

GRANT SELECT ON schema.table to user;

GRANT SELECT ON schema.table to user;

GRANT SELECT ON schema.table to user;

GRANT SELECT ON schema.table to user;

GRANT SELECT ON schema.table to user;

GRANT EXECUTE ON schema.table to user;

GRANT EXECUTE ON schema.table to user;

GRANT EXECUTE ON schema.table to user;

GRANT SELECT ON schema.table to user;

GRANT SELECT ON schema.table to user;

GRANT SELECT ON schema.table to user;

GRANT SELECT ON schema.table to user;

GRANT SELECT ON schema.table to user;

GRANT SELECT ON schema.table to user;

GRANT SELECT ON schema.table to user;

GRANT SELECT ON schema.table to user;

GRANT SELECT ON schema.table to user;

GRANT SELECT ON schema.table to user;

GRANT SELECT ON schema.table to user;

GRANT SELECT ON schema.table to user;

GRANT SELECT ON schema.table to user;

GRANT SELECT ON schema.table to user;

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.


#14

Thanks for working with me offline. This is fixed for 12.8 and the fix will be available in the first public beta.

Michael


#15

Hi Michael.

It seems that I faced with similar problem.

I have WIN 7 64 bit and Toad 12.7 64 bit…

When I run queries that I expect thousands of data after about 2 minutes Toad ‘is not responding’.

There was no problem with previous Toad 12.6.

I have Default editor style’s character case set to Unchanged.

Is there something else I can set in Options or I have to wait fo Toad 12.8

Thanks for response.


#16

A quick question. Is there a reason you’re executing this kind of query using F5 and not F9? F5 has to wait for all data to be returned before displaying results whereas F9 will give you immediate results. In addition, F5 grid results are string representations of the results where F9 will display the actual data types.

Some things to speed up F5 results - don’t display history and don’t show script grids (both in Options -> Scripts). If you need the grid output, F9 is a much better option. Another thought if you simply need the text output is to spool the output to a file. You can run a script like this in either QSR, SQL*Plus or in Toad itself.

set
termout off

spool
c:\scottemp.txt

select
*
from scott.emp;

spool
off;

Hope that helps,

Greg

From: Pawelko [mailto:bounce-Pawelko@toadworld.com]

Sent: Thursday, September 03, 2015 7:27 AM

To: toadoraclebeta@toadworld.com

Subject: RE: [Toad for Oracle - Beta Discussion Forum] Editor hangs executing script with F5

RE: Editor hangs executing script with F5

Reply by Pawelko

It seems that I faced with similar problem.

I have WIN 7 64 bit and Toad 12.7 64 bit…

When I run queries that I expect thousands of data after about 2 minutes Toad ‘is not responding’.

There was no problem with previous Toad 12.6.

I have Default editor style’s character case set to Unchanged.

Is there something else I can set in Options or I have to wait fo Toad 12.8

Thanks for response.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.


#17

We are quickly approaching the end of the release. I encourage you to try the 12.8 beta as soon as possible to see if your problem is the same as others mentioned and fixed already. If it’s still an issue we’ll need to do some more digging.

Michael

On 09/03/2015 07:27 AM, Pawelko wrote:

RE: Editor hangs executing script with F5

Reply by Pawelko
It seems that I faced with similar problem.

I have WIN 7 64 bit and Toad 12.7 64 bit…

When I run queries that I expect thousands of data after about 2 minutes Toad ‘is not responding’.

There was no problem with previous Toad 12.6.

I have Default editor style’s character case set to Unchanged.

Is there something else I can set in Options or I have to wait fo Toad 12.8

Thanks for response.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.


#18

Hi.

Many thanks for so fast replies!!!

Unfortunately no change. I have executed script on table (11,5mln records) with simple condition (none index column) and I expected about 30 records in result.

First execution using F9 … I got results after about 4 minutes … It was OK.

Second and next executions made Toad ‘no responding’ after about 4 minutes.

In previous TOAD version there was no problem with executing scripts that lasted even over 20 minutes.

I also made simple count (without conditions) on above table … Toad after 2 minutes was not responding and after next about 25 seconds I got result.

Generally something makes this version of Toad hangs more often than the previous one.

After instaling TOAD (even previous versions) I heave not changed any Options.

I am waiting for 12.8… :slight_smile:

best regards