Oracle Database Discussions

Hi,

Could you please help me to findout somesolutions for the error.....

This error is coming at random when we are trying to put a select statement to any table in the VoIP DB. This is not related to any particular table in the DB but is related to the whole DB as such.


ERROR CallTagger - java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-04031: unable to allocate 4200 bytes of shared memory ("shared pool","unknown object","sga heap","state objects") -main(34)
java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1ORA-04031: unable to allocate 4200 bytes of shared memory ("shared pool","unknown object","sga heap","state objects")

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:169)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.O3log.receive2nd(O3log.java:515)
at oracle.jdbc.ttc7.TTC7Protocol.logon(TTC7Protocol.java:256)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:252)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:365)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:260)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:37)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:290)
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:816)
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:95)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
at com.hutchison3g.voiprecording.directlogin.database.DBManager.getConnection(DBManager.java:26)
at com.hutchison3g.voiprecording.directlogin.database.DBManager.executeStatement(DBManager.java:153)
at com.hutchison3g.voiprecording.directlogin.main.DirectLogin.main(DirectLogin.java:29)

Thanks in advance:)
kalai