Right Click freeze plsql developer

[vgupta]

I am using a licenced ver 7.1.5. Everytime I right click on any table in sqleditor or clicks on data grid plsql developer hangs for about 20 seconds. It happens every time. Is there any setup I can do to eliminate the this delay?
I am forced to use the Toad now after having this issue.

 

[Marco van der Linden]

Under 'Tools/preferences'/Window Types/SQL Window' uncheck 'Show dictionary info in result grid'. That should speed up things considerably.

 

[vgupta]

Thanks. This fixes the issue related to the result grid but it is still taking a long time in sqleditor and in program window. Is there any other setup required for this?

 

[Marco Kalter]

Can you let me know your Oracle Server version?

 

[vgupta]

10G (Release 10.1.0.5.0 - 64bit)

 

[Marco Kalter]

You may be suffering from Oracle Bug 5074323 ("After Upgrading To 10.1.0.5 Queries On All_Synonyms Slow"). Oracle suggests a workaround by creating a private ALL_SYNONYMS view. Can you try this?

To have similar performance from the ALL_SYNONYMS view on 10g to version 9.2 do the following steps :

1. Create a new view "SYS.ALL_SYNONYMS_920X" with all_synonyms definition from database 920X

2. To force users to select from this new view without code modification, a private synonym can be created:

CREATE SYNONYM username.ALL_SYNONYMS FOR SYS.ALL_SYNONYMS_920X

This is private synonym must be created for any user executing which wants to use the new definition.

Note that the users could also select from the new definition directly but this would require code references to be changed in the application.