Today’s Question:

Are the Tree View fonts configurable? (E.g., Connections). I am using a high-resolution display (1920×1200) and they appear quite small.

And the answer:

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

It's not just the tree font that's bigger...

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:
C:\Users\jdsmith\AppData\Roaming\SQL Developer\system4.\o.sqldeveloper.

Note: my version string at the end might be a different than yours depending on your version of SQL Developer.

You want to open You’ll notice it 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:

# To modify the font size for a particular locale under all
# look-and-feels, set the Ide.FontSize.<languageID> property. For
# example:

If you think 14 looks huge, one of my co-workers has his set to 21!

This doesn’t control the font size for text in the editors and the data grids

We have a preference in the UI for that.


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


  1. Avatar


    I found the right file to ask for bigger font size. When I relaunch Oracle I see the bigger font size but it goes back very fast to the old 11 one… When I check again the specific file I see that my updates were reseted… is ther another trick to keep it like I saved it?


  2. Avatar

    In Version there is an easier way to change the fontsize, but there is something weird with it:
    Open a package body. (I guess it works from a procedure or function as well, but it definitely does *not* work from an SQL Worksheet)
    Now, while holding the CTRL-button (Command on Mac?), use the scrollwheel on your mouse (For Mac: well…): The font increases/decreases . Yay!

    Go back to an SQL Worksheet, and it will use the same fontsize you just set, but weirdly you can’t us CTRL+scroll directly in a SQL Worksheet…

    • thatjeffsmith

      Probably b/c the SQL Worksheet is a … beautiful Frankenstein baby, born of a Code Editor, that JDev gives us in the FCP. So it’s LIKE a code editor, but not really.

Write A Comment

Follow by Email