Updates to Resultset takes more time

[Kiran M]

Hi All,

I am facing the below issue every time when trying to update a field in result grid.

After issuing for update, PL/SQL developer hangs before allowing to change target column/field data for about 20 to 40 seconds. After that it does not hang for any other field updates. But if I issue for update on other table, this issue pops up again and PL/SQL hangs.

I have unchecked the below option, but still id did not resolved the said issue.

Tools/preferences'/Window Types/SQL Window' uncheck 'Show dictionary info in result grid'

PL/SQL Developer Version : 10.0.5.1710

Kindly suggest if any other settings need to be changed.

Regards,
Kiran.

 

[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).