Toad World® Forums

Slow Connection Times


#1

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


#2

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


#3

John:

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”?

Dave


#4

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