Hi all,

We get intermittant ORA-4031 errors when running some Java code with sql via the Oracle's thin JDBC client:

java.sql.SQLException: ORA-04031: unable to allocate 52480 bytes of shared memory ("shared pool","unknown object","library cache","kslcr - unsafe positions")

I am pretty sure its due to undersized structure. But i am not sure whether to increase the shared pool or the java pool. The shared pool is sized to 33554432 (33M). Or is it a bug?. We have 9.2.0.1.0 installed.


Any suggestions?

Thanks in advance,
Chucks_k