Slow column completion in version 11.

[jaw]

Hi,

I am running the 64-bit version 11.0.6, and I've found that some things seem to take an unexplainable long time.

Especially over slower links we all know, and maybe to some degree accept, that the "Code Assistant" is very slow, especially the first time you use it. It has to populate the list of all available objects, etc. What has become a problem since version 11 (if I recall correctly) is that now even selecting a column for completion causes PL/SQL to completely freeze for 2-5 seconds.

Example: SELECT * FROM table a WHERE a.

I mean, come on.. I've already selected the name I want. It just needs to copy the column name I selected to the editor window, but for some reasons it obviously seems like it starts doing slow calls to the database.

This is really, really, REALLY annoying, and completely throws you out of your flow when you are writing queries or code.

So, I would request the following specifics:

• Optimize the the code assistant to increase the performance.
• Stop making calls when not needed (?) (completion of known name)
• Fix code assistant so the entire application doesn't go into "(not responding)" when it makes its database calls

If anyone recognize these issues and may have some other tips for solving them I would be more than happy to hear of it.

Thank you,
Alexander

 

[Marco Kalter]

To obtain some more diagnostic information, can you modify the shortcut and add the DebugSQL parameter? For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" DebugSQL

Reproduce the problem and send me the debug.txt file that is generated in the PL/SQL Developer directory or in the %APPDATA%\PLSQL Developer directory (e.g. C:\Users\\AppData\Roaming\PLSQL Developer).

 

[jaw]

Well, that revealed a lot of interesting things and raised even more questions...

I know now why PL/SQL is so slow starting.. It is spending the first 40 seconds interrogating every connection I have made for some completely unknown reason. Would you mind NOT trying to "check" anything before I actually select which system I want to connect to?

Since I don't seem to be able to attach the file here I'll send it in an email to you.

BR,
//A

 

[IvanZ]

Hi

Try nologon command-line switch.

 

[Athlantis]

I have just come to check is there some likely stuff, and seems it is...

Recently we established 11.2.0.4 x64 and I started to tune it. And after all... select * from user_tables in some schema takes more than 20 secs, SQL*Plus takes less then a second.

But the very interesting thing is at old server 10.2.0.4 plsqldev takes that query less than a second. I use DEV 11.0.4 x32. I've even tried 9.0.6: yesterday firstly at 11.2.0.4 it took less than a sec for that query, but today... You know, I really donno what has changed, I'm trying to turn things back for yestarday...

Tried execute 10 consecutive qeuries select * from user_tables:
At 10.2.0.4 it took les than a second each, but at 11.2.0.4 it varies 44-56s. That is it...