Oracle Sql Developer Heap Space Error, Protocol Error
Solution 1
you can edit sqldeveloper.conf and change the size of the heap space, by adding the following line:
AddVMOption -Xmx4096M
Solution 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
Admin
Updated on July 28, 2022Comments
-
Admin almost 2 years
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?