How To Change Font Size Of The Sql Developer Application? (Doc ID 953455.1)
Steps to change font size of the SQL Developer Application.
To view full details, sign in with your My Oracle Support account.
Don’t have a My Oracle Support account? Click to get started!
In this Document
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.
How to increase size of GUI/font/everything of Oracle SQL Developer 18.1
I downloaded Windows 64-bit with JDK 8 included of SQL Developer 18.1.
To run Oracle SQL Developed I just unzipped the file and run the sqldeveloper.exe contained in the folder.
Unfortunately, as you can see in the image the size of everything is extremely small and very difficult to see.
This issue appears exclusively with this software.
How can I resolve it?
7 Answers 7
I also faced a similar issue when installed this on Windows 10. The issue has to do with compatibility settings.
I have fixed it following the steps given below:
- Get shortcut of sqldeveloper at your desktop
- Ensure that you have admin rights in your PC
- Right Click on sqldeveloper icon and select Properties.
Go to the Compatibility tab:
- Compatibility mode change it to windows 7
- Check the option of Override high DPI scaling beaviour
- Select «System» in drop down below
I guess this is a subjective statement — but that doesn’t appear SMALL to me.
However, if you’re using an OS accessibility feature to increase the size of text in your applications, the new ‘Welcome Page’ can interfere with that.
Uncheck ‘show on startup’ in the Welcome page
Restart SQL Developer.
You should be good.
The Welcome page uses JavaFX to render some HTML and this is apparently getting in the way due to a Java bug. We’re looking to mitigate or fix this for a future release.
If that doesn’t work, you can also try to actually increase the UI font size.
I talk about how to do that here
This is what it looks like bumped up to font size 14
Find your ide.properties file.
Windows: It’s in your OS User’s AppData, Roaming, SQL Developer, systemX.Y.Z. o.sqldeveloper directory where X.Y.Z. represents your version of SQL Developer.
Linux/Mac: It’s in your $HOME/.sqldeveloper, systemX.Y.Z, o.sqldeveloper directory.
You’ll notice this file is VERY well documented. There’s a section that speaks to Windows in particular. To change the default size for all look and feels, add this line, the uncommented one:
How to Change the UI Font Size for Oracle SQL Developer
Oh, but you probably wanted the how as well…OK.
Here’s what the tree UI looks like out of the box on Windows 7, locale US English, with 1600×900 screen resolution and not using any of Windows Accessibility options…
Some PLSQL code that does…
And here’s a look at what it looks like when I bump the font size up to 14 on a normal display in Windows:
And here’s how it looks on a 4k Mac Screen with it set to 21
And here’s where to set that property
In Windows, you want to to go to the Application Data, Roaming Users directory that stores the settings files for SQL Developer. On my machine that’s here:
Note: my version string at the end might be a different than yours depending on your version of SQL Developer.
Nothing striking. My occasional notes on too rare to remember recurrent IT-related tasks. I would be glad if they were of use to anyone else.
Wednesday, March 14, 2018
Changing font size and default language in SQL developer or Data Integrator
Changing the default tiny font size
By default the letters in SQL developer or Data integrator are hardly visible. The steps to increase the font size are quite the same on windows and linux. In %userprofile%/AppData on Windows or $HOME on Linux search for a file ide.properties. One file will be found in SQL developer folder, whereas in ODI folder two files will be found (No idea why because it does not matter).
In SQL developer’s file uncomment a line with Ide.FontSize=18 and set the convienient font size (no less than 18).
Add the the same line to the two ODI files which seems identical on Linux, and different on Windows (the last two pictures).