Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Version 24.3.1 Java Memory -Xms -Xmx Flags

J-Mar 7 2025

Windows 10, SQL Developer 24.3.1

I added the following lines to product.conf file in c:\users\username\appdata\roaming\sqldeveloper\24.3.1

-AddVMOption -Xms1G

-AddVMOption -Xmx4G

However, when I start sqldeveloper.exe (which runs the 64 bit version), in help→about→properties I see the same value for
java.memory.heap.init 134217728
java.memory.heap.max 2147483648
no matter what I change the xms and xmx settings to.

I tried not including the xms flag, tried changing the units to bytes, kilobytes, and megabytes, and tried using the 64 bit specific flags.

I confirmed that help→about→properties for user.conf is pointing to the product.conf file I edited.

I don't think it's a reporting issue, either. When I work on a large model within the Data Modeler extension, I run out of memory at 2G.

This post has been answered by J- on Mar 10 2025
Jump to Answer

Comments

J-
Answer

Solved.

I think this all stems from issues I caused by running two instances of SD at once

https://forums.oracle.com/ords/apexds/post/sql-developerwill-not-start-could-not-install-some-modules-4414

I thought I got past that by deleting the system24.3.1 folder in appdata/roaming/Sql Developer and letting SD recreate the folder. But when I tried that again today to try to troubleshoot the memory issue, I got the same “extensions cannot load” error.

Now, the only way I can run 24.3 is to start it with sqldeveloper64.exe in the bin folder.

The good news is the memory xms/xmx settings are being applied now. So I'll just update my shortcuts to point to 64.exe now and patiently wait for the VS Code extension to get Data Modeler capability.

Marked as Answer by J- · Mar 10 2025
1 - 1

Post Details

Added on Mar 7 2025
1 comment
67 views