# toad hangs up during login

**URL:** <https://forums.toadworld.com/t/toad-hangs-up-during-login/9816>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [September 10, 2010, 2:54pm UTC](https://forums.toadworld.com/t/toad-hangs-up-during-login/9816 "2010-09-10T14:54:23Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![rzarc\_078](https://avatars.discourse-cdn.com/v4/letter/r/97f17d/32.png) [@rzarc\_078](https://forums.toadworld.com/u/rzarc_078)\
**Post date:** [September 10, 2010, 2:54pm UTC](https://forums.toadworld.com/t/toad-hangs-up-during-login/9816/1 "2010-09-10T14:54:23Z")

</div>

Hello

```
     Anybody here encounter a login problem using toad 10.5 in connecting to oracle 11.2. During login process, it goes to this query

```

SELECT owner  
FROM all\_objects  
WHERE object\_name = ‘QU\_VERSION’  
AND object\_type = ‘PACKAGE’  
AND owner = USER  
UNION  
SELECT owner  
FROM all\_synonyms  
WHERE synonym\_name = ‘QU\_VERSION’ AND owner = ‘PUBLIC’  
UNION  
SELECT owner  
FROM all\_synonyms  
WHERE synonym\_name = ‘QU\_VERSION’ AND owner = USER

any inputs is appreciated

---

<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:** [September 10, 2010, 3:21pm UTC](https://forums.toadworld.com/t/toad-hangs-up-during-login/9816/2 "2010-09-10T15:21:12Z")

</div>

I’ve heard of performance problems with ALL\_SYNONYMS in 11gR2. It runs a  
lot better with a RULE hint, but unfortunately, there’s no way to add that  
in Toad 10.5 and Oracle 11. I did fix that for Toad 10.6, so hopefully you will  
be upgrading and the problem will go away soon.

Until then, make sure the statistics on the SYS tables are current (especially  
the tables that ALL\_SYNONYMS uses). If that doesn’t help, you might try  
running the query through the Oracle Tuning Advisor and see if it can generate a  
profile for you.

-John

---

<div class="post-metadata">

**Author:** ![rzarc\_078](https://avatars.discourse-cdn.com/v4/letter/r/97f17d/32.png) [@rzarc\_078](https://forums.toadworld.com/u/rzarc_078)\
**Post date:** [September 10, 2010, 11:33pm UTC](https://forums.toadworld.com/t/toad-hangs-up-during-login/9816/3 "2010-09-10T23:33:01Z")

</div>

I will upgrade to 10.6 .Hopefully, this will fix the problem. Thanks again.

---

<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:** [September 13, 2010, 8:19am UTC](https://forums.toadworld.com/t/toad-hangs-up-during-login/9816/4 "2010-09-13T08:19:30Z")

</div>

There is a setting you’ll have to change once you have 10.6.

Go to Options -\> Oracle -\> Optimizer Hints. You’ll have to add a RULE hint for  
DBA\_SYNONYMS on Oracle 11Gr2.

-John