Code Assistant Causes PL/SQL Developer to Hang on SYS schema

[KurtG]

Hello,

I am noticing PL/SQL Developer hangs when rendering the Code Assistant dropdown on the SYS schema. Is there a way to selectively disable or filter the results for this schema only? Or is it possible there's another setting implicated in the hang? I couldn't find anything in the manual or in the forums mentioning this but if you could point me in the right direction it would be much appreciated. Thanks!

My Code Assistant Settings Page Options:

Automatically activated: true
Delay: 500ms
Filter method for subitems: Contains
Coding Style: Lowercase
Describe Users: all checked
Describe Context: true
Minimum characters: 3
Include columns from DML statements: false
Describe standard functions: true
Show variable and type declarations in a popup: true
Align parameter values when selecting multiple: true
Maximum items on one line when selecting multiple items: 2

 

[Marco Kalter]

The Code Assistant cannot be disable on a per-schema basis. I tested with SYS on various database versions, and it seems to work fine.

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

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

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

 

[KurtG]

Thanks for the quick response Marco. Unfortunately, it seems that with the DebugSQL parameter set, I am receiving ORA-12154 when attempting to connect to all databases. Do you know why that might be occurring or a way to mitigate this? Removing the flag and restarting the application allows TNS to resolve again.

 

[Marco Kalter]

Can you let me know your exact PL/SQL Developer version?

 

[KurtG]

PL/SQL Developer 13.0.6.1911 (64 bit) 01.119040

 

[KurtG]

Just a note in case anyone else is experiencing this issue; I have found pressing the escape key right after qualifying the SYS schema with a period prevents the Code Assistant list from attempting to render which seems to be what is causing the IDE hang. Also, in my IDE I have bumped the User Interface > Code Assistant > Delay to 650ms and removed sequences and synonyms from the Describe Users checkbox section to further reduce the intermittent IDE hangs on the Code Assistant list render.

In my experience, the issue seems to be intermittent and could not be reproduced on a coworker's machine. In fact, all code assistant rendering on his machine seems much faster than on mine, to the point where he has comfortably changed the User Interface > Code Assistant > Delay to 100ms. I am not sure what is causing the discrepancy... possibly a session / env variable or network configuration issue? Regardless, I will update with my findings if I am able to determine the cause or notice a change in this behavior.