Hexa's Blog

How to change DBeaver's heap size?

23/08/2023 @ Saigon etc

Edit /usr/share/dbeaver-ce/dbeaver.ini, change the -Xms and -Xmx. In the example belows, check line 20 and 21.

  • -Xms: It is used for setting the initial and minimum heap size. I set to 1GB.
  • -Xmx: It is used for setting the maximum heap size. I set to 6GB.

On Window, it’s C:\Users\user\AppData\Local\DBeaver\dbeaver.ini or C:\Program Files\DBeaver\dbeaver.ini

On Mac, it’s /Applications/DBeaver.app/Contents/Eclipse/dbeaver.ini

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
-vmargs
-XX:+IgnoreUnrecognizedVMOptions
-Dosgi.requiredJavaVersion=17
--add-modules=ALL-SYSTEM
--add-opens=java.base/java.io=ALL-UNNAMED
--add-opens=java.base/java.lang=ALL-UNNAMED
--add-opens=java.base/java.lang.reflect=ALL-UNNAMED
--add-opens=java.base/java.net=ALL-UNNAMED
--add-opens=java.base/java.nio=ALL-UNNAMED
--add-opens=java.base/java.nio.charset=ALL-UNNAMED
--add-opens=java.base/java.text=ALL-UNNAMED
--add-opens=java.base/java.time=ALL-UNNAMED
--add-opens=java.base/java.util=ALL-UNNAMED
--add-opens=java.base/java.util.concurrent=ALL-UNNAMED
--add-opens=java.base/java.util.concurrent.atomic=ALL-UNNAMED
--add-opens=java.base/jdk.internal.vm=ALL-UNNAMED
--add-opens=java.base/sun.nio.ch=ALL-UNNAMED
--add-opens=java.base/sun.security.ssl=ALL-UNNAMED
--add-opens=java.base/sun.security.util=ALL-UNNAMED
-Xms1G
-Xmx6G
-Ddbeaver.distribution.type=rpm