Connecting to our schemas is very slow due to the following code:
SELECT /*+ ALL_ROWS */ table_name, table_owner FROM ALL_SYNONYMS WHERE owner =
‘PUBLIC’ AND synonym_name = ‘QUEST_COM_TEAM_CODING’
We have a lot of synonyms, so ALL_SYNONYMS is slow. We have “Check for
access to DBA Views” checked and the schemas have the “SELECT ANY
DICTIONARY” system privilege. Why doesn’t the query change to use
DBA_SYNONYMS? That would be very fast.
TIA,
Dave
David Reed
Principal Engineer
Major Projects and Integration
I&C Design Integration Engineering
CWHQ2 318D
Westinghouse Electric Company
Suite 252
1000 Westinghouse Drive
Cranberry Township PA 16066, USA
Phone: +1 (412) 374-6739
Fax: +1 (412) 374-4575
Email: reedda@westinghouse.com
Home Page: www.westinghousenuclear.com