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.<press F6><wait for list><select correct column and hit enter><PL/SQL freezes "(not responding)" pops up>
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