(FAQ)零售模块报表查询结果集过大导致OOM宕机

(FAQ)零售模块报表查询结果集过大导致OOM宕机
原因分析： 判断与零售报表查询相关，查询41万多结果集太大导致内存不足宕机。 旧的报表框架，需要二次开发或行业模块自己实现虚模式取数。 1、418,521个OracleResultSet对象占用约1.3GB。 2、约820M的RptRowSet也是418,521个。加在一起约2.1G。超出JVM堆2048M设置。 3、结合对应的javacore判断问题堆栈如下。与零售报表查询相关，查询结果集太大导致。 "RPC-2" (TID:0x72AF2600, sys_thread_t:0x0AC0B770, state:CW, native ID:0x00007AF0) prio=5 at com/kingdee/eas/framework/report/util/RptRowSet.parse(RptRowSet.java:159) at com/kingdee/eas/framework/report/util/DBUtil$BaseDialect.parseResultSet(DBUtil.java:190) at com/kingdee/eas/framework/report/util/DBUtil.executeQuery(DBUtil.java:150) at com/kingdee/eas/framework/report/util/DBUtil.executeQuery(DBUtil.java:129) at com/kingdee/eas/framework/report/util/DBUtil.executeQuery(DBUtil.java:125) at com/kingdee/eas/rt/report/app/StoreSaleDynamicRptFacadeControllerBean._getReqData(StoreSaleDynamicRptFacadeControllerBean.java:48) at com/kingdee/eas/rt/report/app/AbstractStoreSaleDynamicRptFacadeControllerBean.getReqData(AbstractStoreSaleDynamicRptFacadeControllerBean.java:46) at sun/reflect/NativeMethodAccessorImpl.invoke0(Native Method) at sun/reflect/NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79(Compiled Code)) at sun/reflect/DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43(Compiled Code)) at java/lang/reflect/Method.invoke(Method.java:618(Compiled Code)) at com/kingdee/bos/transaction/EJBTxFacade/TxInvokerBean.invoke(TxInvokerBean.java:116(Compiled Code)) at com/kingdee/bos/transaction/EJBTxFacade/TxInvokerBean.INVOKE_SUPPORTS(TxInvokerBean.java:61(Compiled Code)) at com/kingdee/bos/transaction/EJBTxFacade/TxInvokerBean_LocalObjectImpl_2.INVOKE_SUPPORTS(Bytecode PC:26(Compiled Code)) at com/kingdee/bos/transaction/EJBTransactionProxy.invoke(EJBTransactionProxy.java:179(Compiled Code)) at com/kingdee/bos/transaction/EJBTransactionProxy.invoke(EJBTransactionProxy.java:324(Compiled Code)) at $Proxy332.ge