Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

user7091240Dec 2 2021

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?

Comments

Post Details

Added on Dec 2 2021
9 comments
1,689 views