Return
-
Title
Very Slow when initiating connect to an 11g database. The queries on 'QU_VERSION' that is run dur -
Description
Toad starts up is fine but when initiating a connection to the 11g database it takes a long time (3+mins). This is not a problem for all databases.
-
Resolution
There is no way around that noted script in the connection process, but the following are suggestions to address the performance issue.
RESOLUTION 1:
(Only for Toad 10.6 and newer)
1. In Toad, go to Options | Oracle | Optimizer Hints.
2. Add a RULE hint for DBA_SYNONYMS on Oracle 11G.RESOLUTION 2:
Verify statistics on the SYS tables are current (especially the tables that ALL_SYNONYMS uses).RESOLUTION 3:
Running the query through the Oracle Tuning Advisor and see if it can generate a profile for you.