Toad slow connection as APPS to E-Business Suite
                                                 Last update (2011-12-12 11:20:42)
                                                                                                                   Date added (2011-12-10 21:16:40)

Summary
You may have notice using TOAD 8.6 connecting as APPS to E-Business suite it takes long time. Usually more than 3 minutes.

When connecting as APPS with TOAD, the application is running some queries accessing the oracle dictionary. For example the following query:
select  tabs.table_name, 'APPS', tabs.cluster_name
       , partitioned, iot_type 
       , TEMPORARY, table_type, table_type_owner 
       ,tablespace_name
       , NESTED 
       , last_analyzed
       , Dropped 
         , decode(nvl(buffer_pool, 'x') || upper(partitioned) || 
        nvl(iot_type, 'x'), 'xNOx', 'YES', 'NO') is_External
from sys.user_All_tables tabs where 1=1
order by table_name;
Trying to calculate statistics about the oracle data dictionary won't help solve the problem.

One solutions that worked for me is changing the Toad options:

Go to Toad menu: View ->Options...
Choose the Editors ->General
and for Syntax highlighting Uncheck all the options apart from the "Use on clipboard(RTF format) and "Use when printing".

Uncheck "Highlight table names"
Uncheck "Highlight view names"
Uncheck "Highlight stored procedure names"

Now open a new connection as APPS with TOAD
Reviews
Categories
Oracle DBA-> (147)
  Alertlog (3)
  Archivelog (5)
  Auditing (1)
  Backup - Recovery (19)
  Database files (6)
  Database options (2)
  DB links (2)
  Dependencies (1)
  Dictionary (2)
  Exp-Imp Datapump (6)
  Jobs (2)
  Mview (2)
  Networking (3)
  Objects (7)
  Parameters (2)
  Redologs (6)
  Roles - Grants (2)
  Rollback - Undo (8)
  Segments (3)
  Sequences (2)
  Sessions (14)
  SGA (14)
  Tables (10)
  Tablespaces (10)
  Temp (4)
  Toad (5)
  Transactions (1)
  Upgrade (2)
  Users (3)
Oracle APPS DBA-> (66)
Exadata (1)
Performance Tuning-> (59)
Oracle Real Cases (24)
Oracle Errors (23)
Oracle SQL tricks (32)
Oracle RAC (3)
Oracle Security (8)
Filters
Search