F4/Describe hangs

Toad for Oracle
1

Hi,

for certain "words" I hit F4/Describe on, TOAD hangs for about 20 minutes until it resumes working.
This "words" are either not existing objects (I accidently misspelled something) or combinations of "Package.Function" identifiers - package names alone work.

Looking into the session I see TOAD waiting for the statement

SELECT owner, index_name object_name, 'INDEX' object_type
  FROM sys.all_indexes
 WHERE index_name = :obj AND owner = :own
UNION ALL
SELECT owner, name object_name, 'QUEUE' object_type
  FROM sys.all_queues
 WHERE name = :obj AND owner = :own AND owner = :own
UNION ALL
SELECT owner, trigger_name object_name, 'TRIGGER' object_type
  FROM sys.all_triggers
 WHERE trigger_name = :obj AND owner = :own
UNION ALL
SELECT owner, queue_table object_name, 'QUEUE TABLE' object_type
  FROM sys.all_queue_tables
 WHERE queue_table = :obj AND owner = :own
UNION ALL
SELECT owner, mview_name object_name, 'MATERIALIZED VIEW' object_type
  FROM sys.all_mviews
 WHERE mview_name = :obj AND owner = :own
UNION ALL
SELECT owner, synonym_name object_name, 'SYNONYM' object_type
  FROM sys.all_synonyms
 WHERE synonym_name = :obj AND owner = :own
ORDER BY 3

Specifically the synonym part is the culprit. There are many synonyms and it looks more like an issue with Oracle, but maybe someone has an idea or a setting to disable looking up synonyms/perform a speedier select in this case.

I'm on Oracle 19c with TOAD 17.1.717.3711. The problem existed with TOAD 17.0 and even 12 I've used before.

Thanks,
Thomas

2

It would be speedier if you were granted SELECT on the DBA versions of these views.

3

Thanks John, that did it for me.