do you have a sample script we can use to play with?
I just opened a 1,000,000 line 64,000 KB .sql file in about 8 seconds in version 19.4
How can I upload a file here?
Actually I discovered the issue with the scripts from the logger utility: http://www.oraopensource.com/blog/?category=Logger
The package spec loads in a few seconds, but the package body takes more than 5 minutes.
I reproduced with many other files.
Yup, I see that...not good. Thanks for the report and the test case.
In my case, when I press my keyboard shortcut for "Open Declaration" on the logger package, the spec open up immediately. However pressing the keyboard short cut for "Go to Package/ Body" takes forever to open the logger body and sql developer becomes unresponsive while this is happening.
Steps to replicate.
1) Type logger.logger in the worksheet. "logger" is the owner of the package.
2) Press F4(my shortcut).
3) Once the package spec opens, press F2.
4) It takes around 5 minutes to open the body.
I don't know if it is related to the OP's reported issue.
pretty darn sure it's the exact same issue
Ouch! And even worse, if I close SQL Developer 19.4 with the logger.pkb open, then restart the application, loading hangs for those 5 minutes. Had to delete the system_cache folder under the user settings to clear that up.