Poor performance after moving to 12.2.x from 12.1.x

[chucks]

We recently moved a pluggable database from a 12.1.x system to a new installation of 12.2.0.1.0.

Some operations have gotten incredibly slow (screen grays out for many seconds at a time, compiles take longer, etc.). For example, a find database object search which usually would take 10 seconds or so now takes 15 minutes or more.

Can you suggest what to try to resolve these issues?

 

[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 12\plsqldev.exe" DebugSQL

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