How to prevent SQL developer from freezing the interface when editing long pl/sql code

user7091240

When I edit or modify the code of long PL/SQL program (package, function or procedure), the editor interface in SQL developer will show text 'comparing xxx subprograms' and a back-forth moving blue flash in a rectangle block.

When this happens, the editor is frozen, and I can not do anything, and have to wait for several seconds, and the longer the code, the longer the wait time.

Is there any trick to disable this behavior?

If it is inevitable, is there anyway to reduce the wait time?

thatJeffSmith-Oracle

No trick, it's just a code editor option to disable. You can also adjust settings for the parser in terms of resources to expend on HUGE plsql objects/files.

Günter

https://www.salvis.com/blog/2020/10/10/navigation-in-large-pl-sql-code/

user7091240

Thanks for the information.

I am not bothered by the mentioned 'more time to open. And of course it will consume more memory', and once it is loaded, viewing, scrolling, searching and navigating are working smoothly.

I would like to know more about 'code editor option to disable'.

Thanks.

thatJeffSmith-Oracle

Preferences, Code Editor.

There are options to keep packages in synch, disable it.

user7091240

Do you mean "sync package spec and body"?

thatJeffSmith-Oracle

Yes

user7091240

Unfortunately, it did not work:

Correction: the whole interface is froze, include the blush flash inside the white rectangle, and I am not allowed to switch to any other tab.

Disabled package spec and body sync:

Any advice?

thatJeffSmith-Oracle

uncheck also Supported Gutter Navigation, Quick Documentation

user7091240

Thanks, after I applied the changes, I have not experienced the interface freeze so far.