我正在尝试将Oracle SQL Developer与MySQL数据库一起使用。我可以很好地连接,可以执行查询,可以看到表,选择一个表后,除了“数据”选项卡外,我还可以单击所有选项卡。当我单击“数据”选项卡时,出现一条消息“等待编辑器初始化”,并且SQL Developer冻结。几分钟后,我收到以下堆栈的消息“超出了GC开销限制”
java.lang.OutOfMemoryError: GC overhead limit exceeded at com.mysql.jdbc.MysqlIO.nextRowFast(MysqlIO.java:2114) 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)
我环顾了stackoverflow和google,但找不到适合我的任何东西。我在Windows 7 64位,SQL Developer版本4.0.3.16,MySQL服务器版本5.5上运行此程序。我加了一行
AddVMOption -Xmx1024M
如此处建议,在sqldeveloper \ sqldeveloper \ bin \ sqldeveloper.conf文件中
https://codechief.wordpress.com/2008/07/30/configuring-oracle-sql-developer-for-large-files-fix-out-of-memory-errors/
并在C:\ Users \\ AppData \ Roaming \ sqldeveloper \ 1.0.0.0.0 \ product.conf文件中添加了更改的初始和最大内存分配池大小,
AddVMOption -Xms512m
和
AddVMOption -Xmx1024m
分别。我正在监视性能,但内存并没有耗尽,但是CPU利用率超过90%。
谢谢!