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
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.
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.
12 Comments
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.
I’ve seen your other comments/suggestions floating around out in the wild https://community.oracle.com/tech/developers/discussion/4477224/sql-developer-cant-read-files-from-the-users-documents-folder-in-mac-os
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
Hi Jeff,
After I tried deleting the sqldeveloper configuration directory (~/.sqldeveloper), the problem I mentioned earlier was resolved.
Best Regards,
Yayah
Great!
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 )
Can you be more specific? And it might be easier to talk this one out on the forums.
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.
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.
Hello Jeff.
I still see Version 22.2.0.173.2018 when using https://www.oracle.com/database/sqldeveloper/technologies/download/ link, so should we wait a little bit or is there another way to access new version?
Best Regards.
Piotr
Try clearing your browser cache or use a different browser.
After using different browser (MS Edge) it worked.
Thank you.