We store the application settings PER user. So find where your OS stores files for your OS user.

These settings are stored HERE on Windows (…AppData\Roaming\SQL Developer):
system_directory

They are stored HERE on Macs and *NIX ($HOME\.sqldeveloper):

The number system should look familiar...
The numbering system should look familiar…

Find the directory that corresponds with the version you are running and having problems with. Rename it. Restart SQL Developer – you should be running ‘stock, out of the box.’

This can also come in handy any time the application hangs on a start-up or starts to act weird.

Or if you want to copy settings around, here’s where you’ll find them.

You can also find your SQL History – we store them per User, not per version.

One query/script per file. These are loaded into memory on start-up: hence we don't recommend setting your SQL History limit to 30,000 #TrueStory
One query/script per file. These are loaded into memory on start-up: hence we don’t recommend setting your SQL History limit to 30,000 #TrueStory
Author

I'm a Distinguished Product Manager at Oracle. My mission is to help you and your company be more efficient with our database tools.

20 Comments

  1. Jacek Bogucki Reply

    1. thank you for all this here!! 2. it’s a sick, sad joke from Oracle, that we cannot simply access this article.
    3. otoh: how to reset *just* the windows/panels? something got borked and for the life of me I cannot get “Connections” to become foldable “left pane” with everything else on tabs in “right pane”..

    • Not sure what you mean by ‘sick joke’ – you indeed just accessed it? Googling would find this and more than several articles published on the Oracle Support Knowledge Base.

      SQL Developer Menu > Window > Reset Windows to Factory Settings

  2. Awesome stuff thanks Jeff!

    Just curious if there’s a way to specify the location of this data on startup when on 22.2.1 running on OSX ?

    Cheers,

  3. Hmm, for me in version 21.2.0.187, the hopelessly slow typing problem happens after using it for just 4 weeks. If you expect me to do this every 4 weeks, it is time Oracle fixed the source of the problem! This article is 6 years old and obviously a known problem to Oracle, and they have not done anything it?

    • Phil, there is no known issue/but here for us to fix…that we KNOW of.

      So after a month the editor becomes unusable until you reset your preferences?

      If this is true please open a SR with MOS, share with us your preferences folders, then we can attempt to diagnose/fix the issue.

  4. Vladimir Dj Reply

    Thanks for this article. It helped and resolved problem in a minute.
    🙂

  5. Jeff, is there a way to disable the “Confirm Import Preferences” window on the first run?

    Im guessing its stored somewhere in C:\Users\Administrator\AppData\Roaming\SQL Developer\system18.4.0.376.1900

    • Hi Jeff,

      Thanks for the response. I found C:\Users\Administrator\AppData\Roaming\SQL Developer\system18.4.0.376.1900\o.ide.13.0.0.1.42.170225.20\runStatus.xml controls whether or not the “Confirm Import Preferences” appears on the first run.

  6. You can change the default directory by setting the System Environment Variable IDE_USER_DIR to your new directory.

    Steps worked for me (Windows 10 and SQL Developer Version 17.2.0.188):
    1. Copy all the folder C:\Users\my_user\AppData\Roaming\SQL Developer to the new location, D:\SQL Developer for example
    2. Create a new System Environment Variable IDE_USER_DIR with value D:\SQL Developer
    3. Open SQL Developer and done!

  7. Jeff – I love this blog of yours! Seems like the only good place to find Oracle SQL Dev info…

    Wiping out my history had a superb impact on the speed of starting/stopping SQL Developer.

    I’d already parred things back to fairly minimal functionality (eg lots of things turned off, as per one of the other posts on here which explains about Extensions etc etc) but pretty quickly the speed improvement was being eroded.

    It’s odd as I’ve kept my history setting low (50), but if it’s a choice between no history and fast vs history and slow I’m ditching the history!! There’s clearly something up with the history as CPU goes to 100% and I hear my laptop fan go mental! (it’s a decent-ish work machine, with 8Gb RAM and an SSD)

    Before trying this, I was wondering if something was up with my Java set-up (like some weird path problem) but looks like it was this all along.

    If it’s useful to know: I’m on SQL Dev 4.1.0.19, Win64 with 64-bit JDK (needed for other reasons) 1.8.0_71-b15 (I’ll be updating that shortly)

    • 50 is nothing, you should be fine with probably 5000, esp with SSD…maybe you need to defrag your HD? is that even a thing anymore?

  8. Vince Poore Reply

    We have our own custom setup for SQL Dev where we start with a stock folder, make all our company-wide changes and preferences, then zip up this folder. We’ve customized the Tools menu with a call to a script to reset everything back to the company defaults. The script asks for you to shutdown SQL Dev and then it unzips to the user’s profile directory. It’s also called the first time a new user starts up SQL Dev.

  9. Larry Hopper Reply

    I believe your second sentence should be “AppData\Roaming” not AppDev.

Write A Comment