Oracle Sql Developer Heap Space Error, Protocol Error

Question

I am experiencing something strange while using Oracle SQL Developer 4.0.1.14.

When I connect to a particular db and run a simple select * from table1; I get the result set. (Still happens regardless of the number of records in the table, which is few, however the table does contain over 170 fields)

If I try and run it a second time I get a java heap space error.

If I try and run it again it starts throwing Protocol violation errors, with a different numbered protocol error each successive run.

I have never experienced this problem with other oracle db’s, even when connecting through the same installation of SQL Developer.

The only way for me to be able to query that table again is to reconnect to the db. Other users of this same db do not experience this problem. Has anyone ever experienced this issue?

Answer 1

you can edit sqldeveloper.conf and change the size of the heap space, by adding the following line:

 AddVMOption -Xmx4096M

Answer 2

I know it is too late may be that could help someone else

in the explorer enter %appdata%

that will bring you to your :

C:\Users\username\AppData\Roaming\

Find your sql developer in my case it was:

sqldeveloper

Find a file named: product.conf

Almost at the end of the file change the line:

AddVMOption -Xmx800m

into :

AddVMOption -Xmx2048m