Results 1 to 2 of 2

Thread: ORA-4031 Error

  1. #1
    Join Date
    Nov 2003
    Posts
    1

    Unanswered: ORA-4031 Error

    Hai,
    I am doing a performance test on our product on Oracle 9i on running on Win2K,1Gb RAM.
    I am getting ORA-4031 errors.

    Previously i got 4031 error for large pool,so i increased the large pool size.Then the performance improved but i get 4031 shared pool errors.The performance increases when i still increaed the shared pool.

    Here are the sql parameters
    Shared Pool size - 344Mb,Large pool - 40Mb,Processes - 250.
    Also there seem that select statements which seem to take a lot of memory.

    Here is the actual error i get
    ----------------------------------------------------------------------
    2003-11-04 13:21:34,996 ERROR [org.jboss.ejb.plugins.LogInterceptor] TransactionRolledbackLocalException, causedBy:
    java.sql.SQLException: ORA-04031: unable to allocate 48 bytes of shared memory ("shared pool","SELECT SUB_ID,SUB_CLUEQUESTI...","sql area","qeruas : ruaalo")

    at oracle.jdbc.dbaccess.DBError.throwSqlException(DBE rror.java:180)
    at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:2 08)
    at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
    at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol .java:1451)
    at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe (TTC7Protocol.java:651)
    at oracle.jdbc.driver.OracleStatement.doExecuteQuery( OracleStatement.java:2117)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTi meout(OracleStatement.java:2331)
    at oracle.jdbc.driver.OraclePreparedStatement.execute Update(OraclePreparedStatement.java:422)
    at oracle.jdbc.driver.OraclePreparedStatement.execute Query(OraclePreparedStatement.java:366)
    at org.jboss.resource.adapter.jdbc.WrappedPreparedSta tement.executeQuery(WrappedPreparedStatement.java: 289)
    at org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityComma nd.execute(JDBCLoadEntityCommand.java:165)
    at org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityComma nd.execute(JDBCLoadEntityCommand.java:83)
    at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.lo adEntity(JDBCStoreManager.java:632)
    at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.lo adEntity(JDBCStoreManager.java:614)
    at org.jboss.ejb.plugins.CMPPersistenceManager.loadEn tity(CMPPersistenceManager.java:386)
    at org.jboss.resource.connectionmanager.CachedConnect ionInterceptor.loadEntity(CachedConnectionIntercep tor.java:353)
    at org.jboss.ejb.plugins.EntitySynchronizationInterce ptor.invoke(EntitySynchronizationInterceptor.java: 232)
    at org.jboss.resource.connectionmanager.CachedConnect ionInterceptor.invoke(CachedConnectionInterceptor. java:186)
    at org.jboss.ejb.plugins.EntityReentranceInterceptor. invoke(EntityReentranceInterceptor.java:82)
    at org.jboss.ejb.plugins.EntityInstanceInterceptor.in voke(EntityInstanceInterceptor.java:174)
    at org.jboss.ejb.plugins.EntityLockInterceptor.invoke (EntityLockInterceptor.java:89)
    at org.jboss.ejb.plugins.EntityCreationInterceptor.in voke(EntityCreationInterceptor.java:53)
    at org.jboss.ejb.plugins.AbstractTxInterceptor.invoke Next(AbstractTxInterceptor.java:84)
    at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTran sactions(TxInterceptorCMT.java:243)
    at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxIn terceptorCMT.java:104)
    at org.jboss.ejb.plugins.SecurityInterceptor.invoke(S ecurityInterceptor.java:117)
    at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInt erceptor.java:191)
    at org.jboss.ejb.plugins.ProxyFactoryFinderIntercepto r.invoke(ProxyFactoryFinderInterceptor.java:122)
    at org.jboss.ejb.EntityContainer.internalInvoke(Entit yContainer.java:483)
    at org.jboss.ejb.Container.invoke(Container.java:674)
    at org.jboss.ejb.plugins.local.BaseLocalProxyFactory. invoke(BaseLocalProxyFactory.java:353)
    at org.jboss.ejb.plugins.local.EntityProxy.invoke(Ent ityProxy.java:38)
    at $Proxy260.endSession(Unknown Source)
    at com.bonsai.accessmanager.ejb.session.AccessManager SessionBean.endUserSession(AccessManagerSessionBea n.java:2035)
    at sun.reflect.GeneratedMethodAccessor247.invoke(Unkn own Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:324)
    at org.jboss.ejb.StatelessSessionContainer$ContainerI nterceptor.invoke(StatelessSessionContainer.java:6 29)
    at org.jboss.resource.connectionmanager.CachedConnect ionInterceptor.invoke(CachedConnectionInterceptor. java:186)
    at org.jboss.ejb.plugins.StatelessSessionInstanceInte rceptor.invoke(StatelessSessionInstanceInterceptor .java:72)
    at org.jboss.ejb.plugins.AbstractTxInterceptor.invoke Next(AbstractTxInterceptor.java:84)
    at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTran sactions(TxInterceptorCMT.java:243)
    at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxIn terceptorCMT.java:104)
    at org.jboss.ejb.plugins.SecurityInterceptor.invoke(S ecurityInterceptor.java:117)
    at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInt erceptor.java:191)
    at org.jboss.ejb.plugins.ProxyFactoryFinderIntercepto r.invoke(ProxyFactoryFinderInterceptor.java:122)
    at org.jboss.ejb.StatelessSessionContainer.internalIn voke(StatelessSessionContainer.java:322)
    at org.jboss.ejb.Container.invoke(Container.java:674)
    at sun.reflect.GeneratedMethodAccessor128.invoke(Unkn own Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:324)
    at org.jboss.mx.capability.ReflectedMBeanDispatcher.i nvoke(ReflectedMBeanDispatcher.java:284)
    at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanSe rverImpl.java:549)
    at org.jboss.invocation.jrmp.server.JRMPInvoker.invok e(JRMPInvoker.java:359)
    at sun.reflect.GeneratedMethodAccessor162.invoke(Unkn own Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:324)
    at sun.rmi.server.UnicastServerRef.dispatch(UnicastSe rverRef.java:261)
    at sun.rmi.transport.Transport$1.run(Transport.java:1 48)
    at java.security.AccessController.doPrivileged(Native Method)
    at sun.rmi.transport.Transport.serviceCall(Transport. java:144)
    at sun.rmi.transport.tcp.TCPTransport.handleMessages( TCPTransport.java:460)
    at sun.rmi.transport.tcp.TCPTransport$ConnectionHandl er.run(TCPTransport.java:701)
    at java.lang.Thread.run(Thread.java:536)
    ------------------------------------------------------------------

  2. #2
    Join Date
    Oct 2003
    Location
    Slovakia
    Posts
    482

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •