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
thatjeffsmith
Author

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

11 Comments

  1. 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.

  2. 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!

  3. 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)

    • thatjeffsmith

      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?

  4. 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.

  5. Larry Hopper Reply

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

Write A Comment