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 resolve SQL Developer 22.2.1 spinning issues on File Open/Save?

User_MDLIOOct 4 2022

SQL Developer version: 22.2.1.234.1810-x64
Oracle Database Client: 21.0.0 (WINDOWS.X64_213000_client)
OS: Windows 10 Enterprise (64-bit)
On VPN and running sqldeveloper.exe from C:\Program Files\sqldeveloper

Steps tried to resolve the issue (not in particular order):

  1. Waited until IndexPreferencesTask was done which takes from 3 to 10 minutes (sometimes freezes).
  2. Added the following to: C:\Program Files\sqldeveloper\sqldeveloper\bin\sqldeveloper.conf
    AddVMOption -DIndexedPreferencesCommand=false
  3. Set Preferences - Database - Worksheet - Default path for scripts to: C:\Users\xxxxxx\Desktop\SQL
  4. DISABLED Preferences - Environment - persist file name and directory paths
  5. Changed Look and Feel to Windows under Tools - Preferences - Environment - Look and Feel
  6. Logged off VPN
  7. Checked CPU and Memory used - seems fine at 0-.3% CPU and 28% memory (total processes: 0-16% CPU and 86% Memory).
    Issue persisted in sqldeveloper-22.2.0.173.2018-x64.
This post has been answered by thatJeffSmith-Oracle on Oct 4 2022
Jump to Answer
Comments
Post Details
Added on Oct 4 2022
4 comments
3,413 views