I am trying to use Oracle SQL Developer with a MySQL database. I can connect just fine and I can execute queries, I can see the tables, and with a table selected I can click on all tabs fine with the exception of the "Data" tab. When I click on the "Data" tab, I get a message "Waiting for Editor to initialize" and SQL Developer freezes. After a few minutes I get a message "GC overhead limit exceeded" with the following stack java.lang.OutOfMemoryError: GC overhead limit exceeded at com.mysql.jdbc.MysqlIO.nextRowFast(MysqlIO.java:2074) at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1921) at com.mysql.jdbc.MysqlIO.readSingleRowSet(MysqlIO.java:3278) at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:462) at com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:2997) at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:2245) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2638) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907) at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2030) at oracle.dbtools.raptor.controls.grid.ResultSetTableModel.openResultSet(ResultSetTableModel.java:490) at oracle.dbtools.raptor.controls.grid.ResultSetTableModel.fetchNext(ResultSetTableModel.java:274) at oracle.dbtools.raptor.controls.grid.ResultSetTableModel$4.doWork(ResultSetTableModel.java:686) at oracle.dbtools.raptor.controls.grid.ResultSetTableModel$4.doWork(ResultSetTableModel.java:670) at oracle.dbtools.raptor.backgroundTask.RaptorTask.call(RaptorTask.java:193) at java.util.concurrent.FutureTask.run(FutureTask.java:262) at oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$RaptorFutureTask.run(RaptorTaskManager.java:554) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) at java.util.concurrent.FutureTask.run(FutureTask.java:262) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745) I am running this on Windows 7 64bit, SQL Developer version 4.0.3.16, MySQL server version 5.5. I have added a line AddVMOption -Xmx1024M
in the sqldeveloper\sqldeveloper\bin\sqldeveloper.conf file. I am monitoring the performance and I am not running out of memory, but the CPU utilization rate goes above 90%. Thanks!
|