Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL submitted in worksheet perform Data Dictionary pre-query

FFSJul 9 2014 — edited Jul 10 2014

Hi All,

SQL Developer version: 4.0.0.13 (Windows)

Upon submitting a simple SELECT * FROM <any_app_related_table> query in a worksheet the response time to return results have been awful - this is especially apparent when running the query upon opening the worksheet as a new connection.

I decided to track the activity of my session and found that upon submitting the query the following SQL was executed BEFORE the actual query I wanted is run:

/*+ NO_SQL_TRANSLATION */
select table_owner, table_name from all_synonyms where owner in (user,'PUBLIC') and synonym_name=:1
and not exists (select user, object_name from user_objects where object_name=:2 and object_type in ('TABLE','VIEW'))

Because a couple of our DB's have massive data dictionarys, the above SQL is taking it's time in executing. We have gathered stats on the DD before but this does not make any difference.

Is there any way this kind of "pre-query" behaviour can be switched off within SQL Developer? My colleagues using tools such as TOAD laugh in my face as their queries execute instaneously. I have tried searching for this behaviour on the web but could not find anything.....

PS - I seem to think I've asked this question before as I've seen this behaviour on previous versions also but I think the answer was simply words to the effect of "that's the way SQL Developer operates I'm afraid".

Thanks in advance

This post has been answered by Vadim Tropashko-Oracle on Jul 9 2014
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 2 2023
Added on Jul 9 2014
9 comments
2,138 views