Oracle SQL Developer 3.2.09 is consuming lot of memory on windows 7

Question

Oracle SQL Developer Version 3.2.09 is consuming lot of memory on windows 7.

I can see, after 1/2 days of usage and without closing the this application, the memory consumption is going upto 700 MB.

So, in this case, I need to close the application and again restart.

Any remedies for this can be helpful.

Details of SQL Developer are:

Oracle SQL Developer  Version 3.2.09

Build MAIN-09.30

JDK we are using is JDK 1.6

Answer 1

Add below lines to C:\Users\<<user>>\AppData\Roaming\sqldeveloper\4.2.0\product.conf

For 64 bit SQL Developer add:

Add64VMOption -XX:+UseG1GC
Add64VMOption -XX:MinHeapFreeRatio=15
Add64VMOption -XX:MaxHeapFreeRatio=30

For 32 bit SQL Developer add:

Add32VMOption -XX:+UseG1GC
Add32VMOption -XX:MinHeapFreeRatio=15
Add32VMOption -XX:MaxHeapFreeRatio=30

Restart SQL Developer.

To reduce the memory close only the results pane that has huge result set.

TIP: I typically increase JVM memory to 2 GB so SQL Developer does not crash for queries with large result sets. This can be done by adding below line to product.conf:

Add64VMOption -Xmx2048m

Answer 2

Go to Tools--> Preferences-->Environment.

Change the "Look And Feel" value for Oracle to Windows.

Answer 3

That's the JVM and not SQL Developer.

You're running an old copy of SQL Developer and Java.

Go get Version 17.2 and Java 8 or 9 - it is much more performant/responsive on Windows and will do better garbage collection.

And even so, 700MB of RAM isn't very much for an IDE. Go take a look at what Chrome is using on your system now.