Forum Stats

  • 3,734,156 Users
  • 2,246,898 Discussions


SQL Workbench/J Increase Memory Using -Xmx?

achana Member Posts: 52

If I'm on the wrong forum, apologies.

Very recently, I have to use SQL Workbench/J which I am not too familiar with, it has a habit of running out of memory when I run queries.

Apparently I can edit the workbench.settings file in the .sqlworkbench directory and increase the allocated memory by adding a line with -Xmx1024

Does anyone know the exact syntax?


  • achana
    achana Member Posts: 52

    Just in case anyone is interested, I created a .bat file with one line, like this:

    java -Xmx1024m -jar c:\<the directory where you put the sqlworkbench.jar>

    Put it on the desktop and click on it, the java VM will allocate more memory.

    It worked for me, I can run bigger queries now.

This discussion has been closed.