Slow Connection Times

Connecting to our schemas is very slow due to the following code:

SELECT /*+ ALL_ROWS */ table_name, table_owner FROM ALL_SYNONYMS WHERE owner =


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.



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


Home Page:

I believe the intent was to ensure that you can select from the target table.
There is probably a better way to do that.


Sorry. I never saw your response. Yahoo groups again throwing Emails to the bit bucket. I just thought I would check today on Yahoo Groups for any activity on my topic.

Are you saying that query is not affected by “Check for access to DBA Views”?


re: the yahoo groups, I recommend using the toad world discussion groups instead. Much better interface than yahoo, IMHO.