This discussion is archived
2 Replies Latest reply: Oct 12, 2012 11:32 AM by Gary Graham RSS

public synonyms do not display in 3.2.10.9

968021 Newbie
Currently Being Moderated
Hi,

try to expand Public Synonyms on any database connection and it hangs indefinitely. It appears to be running this sql:

select *
from (
select t.*, substr(concat,1,instr(concat,'/')-1) TABLE_TYPE, substr(concat,instr(concat,'/')+1, length(concat)-instr(concat,'/')) TABLE_ID
from (
select s.synonym_name, s.table_owner, s.table_name, o1.object_id, o1.object_type || '/' || object_id concat
from all_synonyms s, sys.all_objects o1
where s.owner = 'PUBLIC' and s.owner = o1.owner(+) and o1.object_type(+) = 'SYNONYM' and s.synonym_name = o1.object_name(+) ) t )

But that sql runs in a second or so when pasted into a window.

Target database is 11.2.0.3.0 running on OEL.

Anyone else noticed the same problem?

Russell
  • 1. Re: public synonyms do not display in 3.2.10.9
    Jeff Smith SQLDev PM ACE Moderator
    Currently Being Moderated
    How many public synonyms do you have?

    As a work around, can you try the Schema Browser instead? Righ-click on your connection > Schema Browser.

    Set the dropdown to Public Synonyms

    It SHOULD load
  • 2. Re: public synonyms do not display in 3.2.10.9
    Gary Graham Expert
    Currently Being Moderated
    Hi Russell,

    I suppose it's possible there is some special issue with 11.2.0.3 and you've encountered something new; however, this is typically a performance issue rather than a hang. See the following thread:
    3.1 - Public Synonyms - Hanging

    I would add that the cancellation issue has been fixed, but that the window of opportunity is very brief -- just a few seconds at most -- since cancellation only applies to the SQL query. As you note, that is very fast. Once SQL Developer has the result of the query, it begins to render all those individual nodes in the navigator tree. That is what really takes so long and, unfortunately, cannot be cancelled. Use the filter trick mentioned in the other thread to protect yourself from such 'accidental' delays.

    Regards,
    Gary
    SQL Developer Team

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points