Toad World® Forums

toad hangs up during login


#1

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


#2

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


#3

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


#4

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