# toad 10.1.1.8

**URL:** <https://forums.toadworld.com/t/toad-10-1-1-8/9261>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [February 17, 2010, 9:17am UTC](https://forums.toadworld.com/t/toad-10-1-1-8/9261 "2010-02-17T09:17:04Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [February 17, 2010, 9:17am UTC](https://forums.toadworld.com/t/toad-10-1-1-8/9261/1 "2010-02-17T09:17:04Z")

</div>

Hi,

Please can you advise me as to why this version of toad is so much slower than  
9.7?

My laptop has windows xp professional service pack 2, with 2gb of RAM an I  
really seem to be struggling to run anything quick.

Thanks

Kind Regards  
Alison Mumford  
Northgate System Letters Developer  
Business Services - ICT  
Stockport MBC  
0161-474-5477

---

<div class="post-metadata">

**Author:** ![HillbillyToad](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/hillbillytoad/32/190_2.png) [@HillbillyToad](https://forums.toadworld.com/u/HillbillyToad)\
**Post date:** [February 17, 2010, 9:47am UTC](https://forums.toadworld.com/t/toad-10-1-1-8/9261/2 "2010-02-17T09:47:32Z")

</div>

Can you give an example?

There are several new features and options that might be coming into play that  
did not translate well from your 9.7 installation. Did you upgrade or install  
side-by-side?

Jeff

---

<div class="post-metadata">

**Author:** ![Bert\_Scalzo](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/bert_scalzo/32/274_2.png) [@Bert\_Scalzo](https://forums.toadworld.com/u/Bert_Scalzo)\
**Post date:** [February 17, 2010, 9:58am UTC](https://forums.toadworld.com/t/toad-10-1-1-8/9261/3 "2010-02-17T09:58:32Z")

</div>

And don’t forget the toad tuning advisor under the help menu – often  
it will tell you which options you have turned on that cost more to process  
– and quick links to turn them off J

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [February 17, 2010, 11:04am UTC](https://forums.toadworld.com/t/toad-10-1-1-8/9261/4 "2010-02-17T11:04:43Z")

</div>

Glad to see I’m not the only one experiencing this. My Toad 10.1 install from a few weeks ago is S-L-O-W compared to Toad 9.7. I did the Advisor in the help menu as suggested, but nothing of substance.

Examples: It now takes a full minute (I timed it) to bring up Toad the first time. This is with a minimum of other apps running on a machine that has not significantly changed since my Toad 9.7.

If I open a second Toad session, oh boy…my system locks down with the appearance of nothing happening. I can wave my mouse pointer around, but EVERYTHING is frozen for the requisite minute or so.

Occasionally my PC will freeze like this for 10 to 15 seconds even without trying to start another Toad session. None of this happened until the Toad 10 install.

Like Alison, I have Windows XP SP3 with 2GB RAM. I did in upgrade from 9.7. I’ve been using TOAD for about 8 years; never seen one slow things down this much.

Thanks–

- Pete J.

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [February 17, 2010, 11:11am UTC](https://forums.toadworld.com/t/toad-10-1-1-8/9261/5 "2010-02-17T11:11:53Z")

</div>

Hi Jeff,

As far as I can remember it was a side by side install?

Its difficult to give a particular example it seems to be everything, even just  
accepting a parameter into a piece of sql takes long enough to say what’s  
happening where as in the other version its almost instant. Running the same  
piece of sql in 9.7 and 10.1, 9.7 takes 25 seconds and 10.1 takes about a minute  
and a half. It seems to be getting the parameters in to the sql that takes the  
time.

Thanks for your help.

Alison

---

<div class="post-metadata">

**Author:** ![HillbillyToad](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/hillbillytoad/32/190_2.png) [@HillbillyToad](https://forums.toadworld.com/u/HillbillyToad)\
**Post date:** [February 17, 2010, 11:22am UTC](https://forums.toadworld.com/t/toad-10-1-1-8/9261/6 "2010-02-17T11:22:35Z")

</div>

Have you investigate the slow startup time using the DEBUG=1 setting in your  
Toad.ini, restarting toad, then checking under the Help menu? It will show  
everything Toad does on startup, which includes downloading stuff from the web  
now…

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [February 17, 2010, 11:54am UTC](https://forums.toadworld.com/t/toad-10-1-1-8/9261/7 "2010-02-17T11:54:38Z")

</div>

Also check to make sure you add Toad to the exceptions list in your anti-virus  
software.

Jon

On 2/17/2010 11:22 AM, Jeff Smith wrote:

```
Have you investigate the slow startup time using the DEBUG=1 setting in your
Toad.ini, restarting toad, then checking under the Help menu? It will show
everything Toad does on startup, which includes downloading stuff from the
web now…

```

[jcm.vcf](https://global.discourse-cdn.com/quest/original/2X/5/5c23b31c0ba716a1561acaf245a2f129245c2c7e.vcf) (267 Bytes)

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [February 17, 2010, 12:09pm UTC](https://forums.toadworld.com/t/toad-10-1-1-8/9261/8 "2010-02-17T12:09:32Z")

</div>

On Wed, 2010-02-17 at 17:04 +0000, Pete wrote:

> Glad to see I'm not the only one experiencing this. My Toad 10.1 install from a few weeks ago is S-L-O-W compared to Toad 9.7. I did the Advisor in the help menu as suggested, but nothing of substance.
> 
> Examples: It now takes a full minute (I timed it) to bring up Toad the first time. This is with a minimum of other apps running on a machine that has not significantly changed since my Toad 9.7.
> 
> If I open a second Toad session, oh boy...my system locks down with the appearance of nothing happening. I can wave my mouse pointer around, but EVERYTHING is frozen for the requisite minute or so.
> 
> Occasionally my PC will freeze like this for 10 to 15 seconds even without trying to start another Toad session. None of this happened until the Toad 10 install.
> 
> Like Alison, I have Windows XP SP3 with 2GB RAM. I did in upgrade from 9.7. I've been using TOAD for about 8 years; never seen one slow things down this much.

Previous comments have pointed to an interaction problem with Antivirus  
software. Disabling the software reduces Toad startup time to a few  
seconds. People have suggested adding toad to an AV's "whitelist" which  
should have a similar result.

Joseph Charpak  
[jcharpak@worldnet.att.net](mailto:jcharpak@worldnet.att.net)

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [February 17, 2010, 12:28pm UTC](https://forums.toadworld.com/t/toad-10-1-1-8/9261/9 "2010-02-17T12:28:44Z")

</div>

Hi Jeff–just tried your recommendation. The Toad Memory Usage dialog says:

Page File Usage (Virtual Memory): 68 MB  
Working Set Usage (RAM): 72 MB

And the Debug Output window says:

13:12:00 Initializing application  
13:12:01 Creating GlobalDataModule  
13:12:02 Performing Toad’s startup tasks  
13:12:02 Setting Toad help file  
13:12:02 Setting global options  
13:12:02 Updating license key file with app info  
13:12:02 Loading Formatter Plus  
13:12:04 Creating main window  
13:12:04 Create Bitmaps Form  
13:12:05 Restoring dock layout  
13:12:06 Checking for Spotlight  
13:12:06 Checking for SQL Impact  
13:12:06 Initializing Team Coding  
13:12:06 Building quick scripts menu  
13:12:06 Building external tools menu  
13:12:07 Enabling features based on license  
13:12:07 Restoring size and position  
13:12:07 Ribbit!  
13:12:08 Performing Toad’s command line tasks  
13:12:08 Application.Run

However, my timing was exactly one minute again from the moment I clicked on the Toad icon to the moment the connections window popped up. As before, I ran this with very few other apps open. It feels like Toad has this big code base that has to get loaded into memory and do a bunch of setup before it can throw up the slash screen and start rendering the desktop.

- Pete J.

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [February 17, 2010, 12:48pm UTC](https://forums.toadworld.com/t/toad-10-1-1-8/9261/10 "2010-02-17T12:48:39Z")

</div>

Good point. We use McAfee here and if I understand Jeff’s comment earlier, Toad is trying to do some connecting to the Internet as it comes up. If so, that definitely might be the cause. Does Toad try to make other connections in the background during operation? It seems to be slow all the way around, even just switching between two open windows like schema brower and the editor.

- Pete J.

---

<div class="post-metadata">

**Author:** ![mstaszew](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/mstaszew/32/23_2.png) [@mstaszew](https://forums.toadworld.com/u/mstaszew)\
**Post date:** [February 17, 2010, 12:50pm UTC](https://forums.toadworld.com/t/toad-10-1-1-8/9261/11 "2010-02-17T12:50:55Z")

</div>

Hi Jeff,

As far as I can remember it was a side by side install?

Its difficult to give a particular example it seems to be everything, even just  
accepting a parameter into a piece of sql takes long enough to say what’s  
happening where as in the other version its almost instant. Running the same  
piece of sql in 9.7 and 10.1, 9.7 takes 25 seconds and 10.1 takes about a minute  
and a half. It seems to be getting the parameters in to the sql that takes the  
time.

Thanks for your help.

Alison

---

<div class="post-metadata">

**Author:** ![Mark\_Lerch](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/mark_lerch/32/33_2.png) [@Mark\_Lerch](https://forums.toadworld.com/u/Mark_Lerch)\
**Post date:** [February 17, 2010, 1:09pm UTC](https://forums.toadworld.com/t/toad-10-1-1-8/9261/12 "2010-02-17T13:09:06Z")

</div>

As far as connecting to the internet, nothing has changed from the previous version, so I’m not sure if that is it. Like previous versions, it just checks for new Toad Tips upon startup, if that option is set. Options \> StartUp \> “Download Toad Tips once a month” controls it, but that’s been there for quite awhile.

---

<div class="post-metadata">

**Author:** ![HillbillyToad](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/hillbillytoad/32/190_2.png) [@HillbillyToad](https://forums.toadworld.com/u/HillbillyToad)\
**Post date:** [February 17, 2010, 1:19pm UTC](https://forums.toadworld.com/t/toad-10-1-1-8/9261/13 "2010-02-17T13:19:16Z")

</div>

> > accepting param into a SQL

So you’re in the editor, you have a bind such as

Select \* from table where a = :my\_value;

Select \* from table where b = &value;

And you hit F9 and then toad takes way too long to pop up and prompt for the  
values?

---

<div class="post-metadata">

**Author:** ![HillbillyToad](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/hillbillytoad/32/190_2.png) [@HillbillyToad](https://forums.toadworld.com/u/HillbillyToad)\
**Post date:** [February 17, 2010, 1:21pm UTC](https://forums.toadworld.com/t/toad-10-1-1-8/9261/14 "2010-02-17T13:21:27Z")

</div>

If connect time is slow, then running Toad with threaded queries will just  
spotlight this problem even further.

IF you’re running side-by-side you might want to check your options for  
the Startup/General/Oracle pages.

---

<div class="post-metadata">

**Author:** ![Mark\_Lerch](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/mark_lerch/32/33_2.png) [@Mark\_Lerch](https://forums.toadworld.com/u/Mark_Lerch)\
**Post date:** [February 17, 2010, 1:32pm UTC](https://forums.toadworld.com/t/toad-10-1-1-8/9261/15 "2010-02-17T13:32:56Z")

</div>

Here is mine. Takes

Do you have a lot of other applications running? An Oracle db on the client?

Page File Usage (Virtual Memory): 22 MB  
Working Set Usage (RAM): 35 MB

14:27:46 Initializing application  
14:27:46 Creating GlobalDataModule  
14:27:46 Performing Toad’s startup tasks  
14:27:46 Setting Toad help file  
14:27:46 Setting global options  
14:27:46 Saving QuestKey license  
14:27:46 Loading Formatter Plus  
14:27:46 Creating main window  
14:27:46 Create Bitmaps Form  
14:27:46 Restoring dock layout  
14:27:46 Checking for Spotlight  
14:27:46 Checking for SQL Impact  
14:27:46 Initializing Team Coding  
14:27:46 Building quick scripts menu  
14:27:46 Building external tools menu  
14:27:47 Enabling features based on license  
14:27:47 Restoring size and position  
14:27:47 Ribbit!  
14:27:47 Performing Toad’s command line tasks  
14:27:47 Application.Run

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [February 17, 2010, 1:35pm UTC](https://forums.toadworld.com/t/toad-10-1-1-8/9261/16 "2010-02-17T13:35:25Z")

</div>

This sounds exactly like the antivirus problem mentioned before. Add Toad to the  
list of programs to not scan in your virus scanner.

---

<div class="post-metadata">

**Author:** ![GTDG](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gtdg/32/140_2.png) [@GTDG](https://forums.toadworld.com/u/GTDG)\
**Post date:** [February 17, 2010, 1:37pm UTC](https://forums.toadworld.com/t/toad-10-1-1-8/9261/17 "2010-02-17T13:37:11Z")

</div>

Pete,  
Have you tried adding Toad as an exception in McAfee?

Greg

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [February 17, 2010, 1:40pm UTC](https://forums.toadworld.com/t/toad-10-1-1-8/9261/18 "2010-02-17T13:40:54Z")

</div>

The queries don’t even have to be running for this to happen! Just seems like the Toad footprint when its running is huge and stepping on the system resources.

I’ve been watching the Task Manager when I do simple things in Toad like open a new connection, close a connection, and bring Toad down and back up. Lots of CPU topping out at 100%, some page swapping, and occasional freezing of other applications while it’s doing the task.

- Pete J.

---

<div class="post-metadata">

**Author:** ![HillbillyToad](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/hillbillytoad/32/190_2.png) [@HillbillyToad](https://forums.toadworld.com/u/HillbillyToad)\
**Post date:** [February 17, 2010, 2:00pm UTC](https://forums.toadworld.com/t/toad-10-1-1-8/9261/19 "2010-02-17T14:00:17Z")

</div>

What if you configure toad to not auto-open any windows, even the connection  
prompt?

---

<div class="post-metadata">

**Author:** ![Guest](https://avatars.discourse-cdn.com/v4/letter/g/8dc957/32.png) [@Guest](https://forums.toadworld.com/u/Guest)\
**Post date:** [February 17, 2010, 2:01pm UTC](https://forums.toadworld.com/t/toad-10-1-1-8/9261/20 "2010-02-17T14:01:09Z")

</div>

Hi Mark–no, I have very few applications running at the time, namely:

- Thunderbird email client
- Oracle Collaboration Suite Calendar
- Windows Task Manager

I’m not running an Oracle Database instance on this machine.

The several suggestions about McAfee make sense and I’ve put in a help desk with our security people to have them whitelist Toad. Fingers crossed!

- Pete J.

[Next page](https://forums.toadworld.com/t/toad-10-1-1-8/9261.md?page=2)
