Slow logon and code completion with PLSD ver. 11 on Exadata 12c

[Ron E]

Since we moved to Exadata, logging on has started taking from 30 seconds to 5 minutes and displaying table or column names with code completion takes 30 seconds to a minute or two. During that time, the screen is greyed out and frozen most of the time. Dell sent a work-around for their competing 'T***' product, which had the user put the RULE hint back into queries against several of the catalog tables to speed those back up. Is there an option to do something like that here?

(We also vote for an enhancement check box like that product has, which switches internal queries like 'Sessions' to use the GV$ views instead of V$.)

PLSD 11.0.6.1776 with Oracle 12c rel. 12.1.0.2.0

thanks,

Ron

 

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

 

[Ron E]

I emailed a copy of the log to Support@.... Let me know if there's a better way.

thanks

Ron