【结】请求]进程内存报错

Crazy_wen2006

CommandText: select TFLOWID.FFLOWGUID AS A1, TFLOWID.FID, TFLOW.FGUID, TTASK.FFL
OWGUID, TTASK.FSUBJECT, TTASK.FCREATETIME, TTASK.FSPOSITIONNAME, TTASK.FSPERSONN
AME, TTASKMESSAGE.FRECEIVETIME, TTASKMESSAGE.FRDEPTNAME, TTASKMESSAGE.FRPOSITION
NAME, TTASKMESSAGE.FRPERSONNAME, TTASKMESSAGE.FFINISHTIME, TTASKMESSAGE.FSTATE,
TTASK.FGUID as TaskGuid, TTASK.FSTATE as TaskState from TFLOWID, TFLOW, TTASK, T
TASKMESSAGE where (TFLOWID.FFLOWGUID = TFLOW.FGUID and TFLOW.FGUID = TTASK.FFLOW
GUID and TTASKMESSAGE.FTASKGUID = TTASK.FGUID and TTASKMESSAGE.FSTATE <> 'tmsCan
celed') AND (((TFLOWID.FCLIENTACCOUNT = 'JUSTEP.COM')))
2010-1-9 8:29:30 com.caucho.hessian.server.HessianSkeleton invoke
警告: java.lang.Exception: error occur during invoke getRecords method, ORA-0403
0: 在尝试分配 123404 字节 (QERHJ hash-joi,kllcqas:kllsltba) 时进程内存不足

java.lang.Exception: error occur during invoke getRecords method, ORA-04030: 在
尝试分配 123404 字节 (QERHJ hash-joi,kllcqas:kllsltba) 时进程内存不足

        at com.justep.service.BizServiceImp.execute(Unknown Source)
        at sun.reflect.GeneratedMethodAccessor131.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at com.caucho.hessian.server.HessianSkeleton.invoke(HessianSkeleton.java
:157)
        at com.justep.hessian.HessianServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:252)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:213)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:178)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:126)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:105)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:107)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:148)
        at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcesso
r.java:831)
        at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.pr
ocess(Http11AprProtocol.java:652)
        at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:12
03)
        at java.lang.Thread.run(Thread.java:595)
Time: 2010-1-9 8:29:53
java.sql.SQLException: ORA-04030: 在尝试分配 123404 字节 (QERHJ hash-joi,kllcqas
:kllsltba) 时进程内存不足

        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:125)
        at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:630)
        at oracle.jdbc.driver.T2CStatement.execute_for_describe(T2CStatement.jav
a:841)
        at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleState
ment.java:896)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
nt.java:986)
        at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:
1125)
        at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeQuery(Delegati
ngStatement.java:205)
        at com.justep.service.database.Query.doOpen(Unknown Source)
        at com.justep.service.database.Query.open(Unknown Source)
        at com.justep.service.database.Query.setActive(Unknown Source)
        at com.justep.service.action.database.GetRecordsAction.doExecute(Unknown
Source)
        at com.justep.service.action.base.SQLAction.doExec(Unknown Source)
        at com.justep.service.action.base.SupportAction.execute(Unknown Source)
        at com.justep.service.action.base.SupportAction.execute(Unknown Source)
        at com.justep.service.BizServiceImp.execute(Unknown Source)
        at sun.reflect.GeneratedMethodAccessor131.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at com.caucho.hessian.server.HessianSkeleton.invoke(HessianSkeleton.java
:157)
        at com.justep.hessian.HessianServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:252)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:213)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:178)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:126)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:105)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:107)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:148)
        at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcesso
r.java:831)
        at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.pr
ocess(Http11AprProtocol.java:652)
        at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:12
03)
        at java.lang.Thread.run(Thread.java:595)
CommandText: select TFLOWID.FFLOWGUID AS A1, TFLOWID.FID, TFLOW.FGUID, TTASK.FFL
OWGUID, TTASK.FSUBJECT, TTASK.FCREATETIME, TTASK.FSPOSITIONNAME, TTASK.FSPERSONN
AME, TTASKMESSAGE.FRECEIVETIME, TTASKMESSAGE.FRDEPTNAME, TTASKMESSAGE.FRPOSITION
NAME, TTASKMESSAGE.FRPERSONNAME, TTASKMESSAGE.FFINISHTIME, TTASKMESSAGE.FSTATE,
TTASK.FGUID as TaskGuid, TTASK.FSTATE as TaskState from TFLOWID, TFLOW, TTASK, T
TASKMESSAGE where (TFLOWID.FFLOWGUID = TFLOW.FGUID and TFLOW.FGUID = TTASK.FFLOW
GUID and TTASKMESSAGE.FTASKGUID = TTASK.FGUID and TTASKMESSAGE.FSTATE <> 'tmsCan
celed') AND (((TFLOWID.FCLIENTACCOUNT = 'JUSTEP.COM')))
2010-1-9 8:30:28 com.caucho.hessian.server.HessianSkeleton invoke
警告: java.lang.Exception: error occur during invoke getRecords method, ORA-0403
0: 在尝试分配 123404 字节 (QERHJ hash-joi,kllcqas:kllsltba) 时进程内存不足

java.lang.Exception: error occur during invoke getRecords method, ORA-04030: 在
尝试分配 123404 字节 (QERHJ hash-joi,kllcqas:kllsltba) 时进程内存不足

        at com.justep.service.BizServiceImp.execute(Unknown Source)
        at sun.reflect.GeneratedMethodAccessor131.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at com.caucho.hessian.server.HessianSkeleton.invoke(HessianSkeleton.java
:157)
        at com.justep.hessian.HessianServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:252)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:213)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:178)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:126)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:105)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:107)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:148)
        at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcesso
r.java:831)
        at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.pr
ocess(Http11AprProtocol.java:652)
        at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:12
03)
        at java.lang.Thread.run(Thread.java:595)
Time: 2010-1-9 8:31:29
Time: 2010-1-9 8:31:59
Time: 2010-1-9 8:32:33
Time: 2010-1-9 8:33:48
Time: 2010-1-9 8:33:55
java.sql.SQLException: ORA-04030: 在尝试分配 1048588 字节 (QERHJ hash-joi,QERHJ
Hash Table Entries) 时进程内存不足

        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:125)
        at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:630)
        at oracle.jdbc.driver.T2CStatement.execute_for_describe(T2CStatement.jav
a:841)
        at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleState
ment.java:896)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
nt.java:986)
        at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:
1125)
        at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeQuery(Delegati
ngStatement.java:205)
        at com.justep.service.database.Query.doOpen(Unknown Source)
        at com.justep.service.database.Query.open(Unknown Source)
        at com.justep.service.database.Query.setActive(Unknown Source)
        at com.justep.service.action.database.GetRecordsAction.doExecute(Unknown
Source)
        at com.justep.service.action.base.SQLAction.doExec(Unknown Source)
        at com.justep.service.action.base.SupportAction.execute(Unknown Source)
        at com.justep.service.action.base.SupportAction.execute(Unknown Source)
        at com.justep.service.BizServiceImp.execute(Unknown Source)
        at sun.reflect.GeneratedMethodAccessor131.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at com.caucho.hessian.server.HessianSkeleton.invoke(HessianSkeleton.java
:157)
        at com.justep.hessian.HessianServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:252)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:213)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:178)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:126)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:105)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:107)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:148)
        at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcesso
r.java:831)
        at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.pr
ocess(Http11AprProtocol.java:652)
        at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:12
03)
        at java.lang.Thread.run(Thread.java:595)
CommandText: select TFLOWID.FFLOWGUID AS A1, TFLOWID.FID, TFLOW.FGUID, TTASK.FFL
OWGUID, TTASK.FSUBJECT, TTASK.FCREATETIME, TTASK.FSPOSITIONNAME, TTASK.FSPERSONN
AME, TTASKMESSAGE.FRECEIVETIME, TTASKMESSAGE.FRDEPTNAME, TTASKMESSAGE.FRPOSITION
NAME, TTASKMESSAGE.FRPERSONNAME, TTASKMESSAGE.FFINISHTIME, TTASKMESSAGE.FSTATE,
TTASK.FGUID as TaskGuid, TTASK.FSTATE as TaskState from TFLOWID, TFLOW, TTASK, T
TASKMESSAGE where (TFLOWID.FFLOWGUID = TFLOW.FGUID and TFLOW.FGUID = TTASK.FFLOW
GUID and TTASKMESSAGE.FTASKGUID = TTASK.FGUID and TTASKMESSAGE.FSTATE <> 'tmsCan
celed') AND (((TFLOWID.FCLIENTACCOUNT = 'JUSTEP.COM')))
2010-1-9 8:34:50 com.caucho.hessian.server.HessianSkeleton invoke
警告: java.lang.Exception: error occur during invoke getRecords method, ORA-0403
0: 在尝试分配 1048588 字节 (QERHJ hash-joi,QERHJ Hash Table Entries) 时进程内存
不足

java.lang.Exception: error occur during invoke getRecords method, ORA-04030: 在
尝试分配 1048588 字节 (QERHJ hash-joi,QERHJ Hash Table Entries) 时进程内存不足

        at com.justep.service.BizServiceImp.execute(Unknown Source)
        at sun.reflect.GeneratedMethodAccessor131.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at com.caucho.hessian.server.HessianSkeleton.invoke(HessianSkeleton.java
:157)
        at com.justep.hessian.HessianServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:252)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:213)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:178)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:126)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:105)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:107)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:148)
        at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcesso
r.java:831)
        at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.pr
ocess(Http11AprProtocol.java:652)
        at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:12
03)
        at java.lang.Thread.run(Thread.java:595)

shangxy

ORA-04030
去网上看看这个错误，给我的感觉好像oracle的pga内存不够用了。
你可以看看oracle 的console中建议的pga大小是多大？

Crazy_wen2006

已更改PGA内存，再观察一下，谢谢。结贴