Compile Invalid Objects freeze

[Allyourbase]

Good afternoon!
Could you tell me if it is possible to not load the list of users in the User on the Compile invalid object menu? Because of the large number of users, the menu loads very slowly.

 

[Marco Kalter]

Does the delay occur when you click on the "User" selection list?

 

[Allyourbase]

Thanks for the clarifying question! No, the delay occurs immediately when you open the Compile Invalid Ojbects tab. But similar delays occur on the Find database objects tab when clicking on Owner. That's why I decided that the issue is in Users.
By the way, the default value for Users is Current User, and the list of disabled objects turns out to be empty

 

[Marco Kalter]

Okay. 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 15\plsqldev.exe" DebugSQL

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

 

[Allyourbase]

attached the debug.txt file to the post. thank you
View attachment Debug.txt

 

[Marco Kalter]

Thanks. I see that there are almost 5.000 users in this database, and that it takes 13 seconds to fetch them. I don't have any immediate workarounds for this situation, so we'll have to implement a solution in the next release.

 

[Allyourbase]

Thank you very much!
Can you tell me, will the fix be only in version 15 or can it be applied to version 14 as well?

And, if possible, after the fix, please post a message in this thread, I'll keep an eye here

 

[Marco Kalter]

The fix will only be applied to version 15.

 

[Allyourbase]

Ok. Thank you!