I'm running SQL Developer 3.2.20.09 on osx 10.8.4 with Java 1.6.0_45 against Oracle 11.1.0.7.0
In my preferences I have the Database->Worksheet->"Show query results in new tabs" option selected.
After a certain number of executions of a select statement against a table I get the message "Java heap space".
SQL Developer is then locked up and all I can do is force quit and start over, reconnection is not possible.
If I disconnect and then re-connect prior to getting the exception then I can continue on until the limit is reached.
If I turn off the "show query results in new tabs" option, then I don't get this error.
The limit for me seems to be 8 selects against a 25 column table or 4 selects against a 50 column table or it will fail on the first select of a table with 135 columns.
Note that the columns are all varchar2(2000).
It would be great if this error could be handled more gracefully since anything else I was doing in other connections is then lost.