Forum Stats

  • 3,838,748 Users
  • 2,262,397 Discussions
  • 7,900,749 Comments

Discussions

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

Oracle-user2
Oracle-user2 Member Posts: 132 Bronze Badge
edited Feb 27, 2022 5:51AM in SQL Developer


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



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.

Tagged:

Best Answer

Answers