sqldeveloper 21.4 vs dbeaver windows memory consumption is 1.3gig vs. 300meg with no active conxns

Oracle-user2

jstack_trace_dump.log

sqldeveloper_dbeaver_windows_mem_footprint.png

both sql developer (only dba/file nav, schema brwsr,security,javase features are selected with windows look/fee, -Xms2048m&-Xmx4096ml) & dbeaver are launched with no active connections in either. (SQL Dev is re-launched after 'show welcome page at start up' is deselected)

attached is mem consumption where sql developer uses 1.3gig (in windows 10 task manager though jvisualvm shows 200meg for each heap/non-heap category) & dbeaver uses 300meg.

reviewed the way windows task manager displays memory usage by reviewing quite informative article

https://stackoverflow.com/questions/12017437/jvm-memory-why-memory-on-task-manager-difference-with-jprobe-or-jconsole-tool

https://stackoverflow.com/questions/12017437/jvm-memory-why-memory-on-task-manager-difference-with-jprobe-or-jconsole-tool

with this huge difference in memory consumption between sql developer and dbeaver, the latter seems to have light mem footprint and wondering if the same can be achieved even with sql developer.

aggressive GC collection options are already configured & as mentioned, jvisualvm shows only 200meg for each heap/non-heap.

jstack trace dump is attached.

@thatJeffSmith-Oracle / SMEs - look forward to your insights around tuning this.

User_H3J7U

Xms2048m&-Xmx4096m

Set ms512m, garbage colector will try to free up memory over this size.

User_H3J7U

Xms2048m&-Xmx4096m

Set ms512m, garbage colector will try to free up memory over this size.

Oracle-user2

thx @User_H3J7U.

with above ms512m config, mem in windows task manager now shows 700meg & heap's at 200meg.

is there an ideal config that reflects the same memory size across all the different windows memory categories displayed in windows task manager for OSD - just like in dbeaver?

thatJeffSmith-Oracle

Since dbeaver doesn't use the FCP via JDeveloper, then I'm not sure sure how useful those comparisons will be.

I'm more worried when someone says their machine or process becomes sluggish, unresponsive.

Oracle-user2

thx, @thatJeffSmith-Oracle