Mostly Making oracle easy, mostly:
Search for:
ThatJeffSmith
In SQL Developer

Oracle SQL Developer for the Mac: Easy & Fast!

2 Mins Read

Oracle SQL Developer for the Mac (and Windows and Linux)

For many years we’ve offered a download for Windows users that included an Oracle JDK embedded in the software package.

Starting today, we’re now offering the same for both hardware chipsets offered by Apple

M1/M2 with ARM-based systems-on-a-chip? We have you covered!

My friends with ARM architecture equipped Macs are telling me that SQLDev is easier 4x faster now that it’s using an ARM JDK.

No more complicated ‘How to’ guides for SQLDev and Macs

Here’s all you need to do now:

  • download the appropriate APP
  • in Finder, drag to Applications
  • launch it

It will use the Java Home embedded in your SQLDeveloper app.

You can see this if you open up the Application properties.

It’s a Java 11 distribution, and we make sure the FX libraries are there as well.

My Mac Mini is from 2018, so it’s an ‘old Intel’ chip based piece of hardware. However, I’ve had several internal folks with fancy new M1’s tell me the ARM version of the download fires right up 🙂

For all OS updates, there’s a single bug fix as well

When creating/editing tables, if you tried to go into the advanced column properties, you’d get a nasty Java error. That’s fixed now.

Ta-da.
thatjeffsmith
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.

Related Posts

12 Comments

  1. Avatar
    Chase Marler Reply

    Any chance you have pro tips on allowing File/Folder access for SQL Developer? Added the SQL Developer app to the Full Disk Access list as well as the Java inside sqldev’s java_home, but I’m unable to navigate anywhere on my computer outside my home directory using SQL Developer.

  2. Avatar
    Yayah Ghoal Reply

    Hi Jeff,

    I’m on a Macbook M1 and have downloaded SQL Developer 22.2.1.234 Mac ARM64 with JDK11 included.
    When running from the SQL Developer Launcher, it stops at the opening window with the status message Loading.
    But I can run it via Terminal Command Line directly, with the command /Applications/SQLDeveloper.app/Contents/MacOS/sqldeveloper.sh

    What do I need to do to get it to run through the launcher?

    Best Regards,
    Yayah

    • Avatar
      Yayah Ghoal

      Hi Jeff,

      After I tried deleting the sqldeveloper configuration directory (~/.sqldeveloper), the problem I mentioned earlier was resolved.

      Best Regards,
      Yayah

  3. Avatar
    Boris Reply

    Hi Jeff,

    just installed version 22.2.1.234 ( windows user here ), it seems that autocomplete for packages/procedures/functions is not working at all, at least for me. I installed(
    On my last version 20.2 pck/proc/fnc autocomplete works fine

    Is there any tweak for that? I checked options and everything in “Code Editor/Completion Insight” is set on, speed is 0,4 sec

    Table/Column autocomplete works well ( faster than my last version )

    • Avatar
      Alexandre

      Hi Jeff.

      I’m facing a weird situation when trying to edit table definitions, maybe you can help me.
      I open the table definitions, and after pressing the button “edit”, the dialog “Preparing editor for null” shows up, and it takes a long long time until I can actually navigate and modify table definition (more than 10 minutes).
      I checked my session activity from another SQL client, and it seems to be stuck in this query:

      SELECT /*OracleDictionaryQueries.ALL_COLUMN_ORACLE12c_QUERY*/
      C.COLUMN_NAME, C.DATA_TYPE, C.DATA_TYPE_OWNER, C.DATA_LENGTH, C.DATA_PRECISION, C.DATA_SCALE, C.NULLABLE, C.DEFAULT_LENGTH, C.CHAR_LENGTH, C.DATA_DEFAULT,
      ( SELECT CMT.COMMENTS FROM SYS.DBA_COL_COMMENTS CMT
      WHERE C.OWNER = CMT.OWNER AND C.TABLE_NAME = CMT.TABLE_NAME
      AND C.COLUMN_NAME = CMT.COLUMN_NAME) COMMENTS decode(C.CHAR_USED, ‘B’, ‘BYTE’, ‘C’, ‘CHAR’,null)
      , C.DATA_TYPE_MOD, C.VIRTUAL_COLUMN, C.IDENTITY_COLUMN, C.DEFAULT_ON_NULL
      FROM SYS.DBA_TAB_COLS C
      WHERE C.OWNER = :1 AND C.TABLE_NAME = :2 AND C.HIDDEN_COLUMN = ‘NO’
      ORDER BY C.COLUMN_ID

      OK, this query is doing exactly what it takes to allow editing the table, but for some reason it is slow, very slow.
      Só I tried to run this statement removing the subselect which retrieve the comments, and it runs almost instantaneously.
      Not sure if it started to happen after some upgrade on OSD or after our company database migration (it is currently on 19c).

      Any clue?

      Thanks in advance.

    • thatjeffsmith
      thatjeffsmith Post Author

      That query hasn’t changed in many, many years.

      You can ask your DBA to check data dictionary stats or grant you access to DBA_ views, which will all be faster than ALL_ views.

Write A Comment